2 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

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.

submitted by /u/Late_Sundae
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#generative AI for data analysis
#natural language processing for spreadsheets
#real-time data collaboration
#big data management in spreadsheets
#conversational data analysis
#intelligent data visualization
#AI formula generation techniques
#Excel compatibility
#rows.com
#POS server
#restaurant contest report
#menu item
#unique names
#excel formula
#server name
#countif
#sumif
#quantity
#excel sheet