Dear readers,
I am wondering how i could start a new count when the value in a certain cell changes value. I want to count the amount of user_pick in column B per match_id in column A. For match_id 1, the count_1 should thus be 15, count_2 should be 0 and count_3 should be 1.
Then a new count should start at row 18 for the new match_id. Could anybody help me with this? Thank you very much in advance!
Best,
George
Bookmarks