• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

by Date Individual Production Summary

Lasantha

Member
Dear Team,
Kindly look into the attached template. It contains daily allocation and completed volume by date and employee. Could you please help me to get a summary by individual and by date individual completed volume to the summary sheet.

Thank you very much for your time

(Excel 2016)

~Lasantha.
 

Attachments

Lasantha

Member
Hi @Shawnhet ,
Sorry for the delaying response to this.

This is great , thank you very much for you time.:)
Completion volume on the 1st table, shows total for the entire month.
Could you please edit it , as display for the selected date.
Ex: when we select 7/15/2022, from the dropdown, I can get the completed volume as of 07/15/2022 only.


Thank you very much.
-Lasantha.
 

Shawnhet

New Member
Oh, sorry - I guess I hadn't copied it over for that column.

just copy the formulae from c5:c14 to d5:d14 and add the following in RED to each.

=OFFSET(Agent1!$B$2,22,MATCH($B$2,Agent1!$C$2:$BL$2,0)+1)

Cheers, :)
 
Top