Hello everyone,
I'm only a novice at excel, so forgive me if this is a simple one, but I have been unable to find a formula that works for this calculation.
I'm looking for a formula that counts the number of times the value in a column is the lowest/highest when compared to adjoining cells for a given criteria.
So in the example attached, I'm looking to count how many times each person had the best score in January.
I've tried a few different COUNTIFS and SUMIF but can't come up with one that works. Thanks for your help
Bookmarks