I've got an Excel list that looks like this (with the name in column A and the score in column B):
I need to rank each person by their highest number of consecutive results of 7.
So Jim's result would be 2, because he got a score of 7 twice in a row.
Ted's would be 2, because he also got a score of 7 twice in a row (albeit twice, but that doesn't matter).
Paul's would be 5, because he got a score of 7 fives times in a row.
How do I get Excel to tell me what the longest string of scores of 7 was for each person?
This is a very long list.
Thanks!
برچسب:
نویسنده: استخدام کار