I was trying to find a way to count the number of times a given row has the maximum value in the column. Was that confusing enough? Basically, in rows I have scores for a given group over a ten week period. For each week there is one or more groups which have the highest score, and I'd like to know how many times each group "won" the week over that ten week period.

I attached an example spreadsheet in which I've highlighted the highest value for each week column (using conditional formating) and (manually) counted the times that group had the highest value. Is there a way to automate this (I have a larger data set and would like to not have to do it manually).

Groups.xlsx