Need a formula to count the number of times a unique name is entered for each date
Hi, I export from a POS server weekly to gather data for a restaurants contest report. When I first started pulling the data from the POS server the excel sheet would count each menu item I filtered for the contest separate regardless of if it was the same server. So I was using =UNIQUE(C2:C5000) C being the servers name. and then using =COUNTIF(C2:C5000), M2. Since C column is the servers name and it was only counting one each time the server rang in that menu item.
Then I found it was breaking it up by unique check number. So I was still using the first formula to find only the eligible names for this. Then I used =SUMIF($C$2:$C$5000, M2, $I$2:$I$5000). so even if one line had 2 or 3 entries it would tally correctly.
The issue is that I have "dummy employees" set up for the bartenders so I am manually tracking the days they rang in this menu and how many times they rang it in. Is there a way to separate the number of times this dummy employee rang in a menu item on each date?
The columns that I need are data from are B (date the menu item was rang in), C (Server name), and I (Quantity of menu item per check). I used the unique formula in cell L, copy and paste into cell M, and finally track my numbers in cell N. I appreciate any help.
[link] [comments]
Want to read more?
Check out the full article on the original site