How to count number of wins based on times a name has the highest number of points
I want to be able to count the number of times someone wins by counting the number of times they have the most points on a given day. I hand wrote in the column I results just for this. Everything else F to H is calculate with code so all I need to do is input the information A-D. Need I to just give me the number of times each user had the highest number of points based on the letter day compared to the other submissions on that day.
I added the highlight and lines just for visual but they aren't usually there, the actual data is also hundreds of lines doing it manually would be annoying.
Link is the photo doesn't show
I know that I can do this at the end with a pivot table but I would love to have it be auto updating as new days are added.
Thank you!
[link] [comments]
Want to read more?
Check out the full article on the original site