I'm trying to Rank the number of times a name show's up in a particular column ("Report Data" Column B) and have it Rank the top ten on another sheet ("Report" starting in cell A16). I haven't been successful finding anything while googling. Does anyone have a good reference video or would like to share what it would look like?
Example:
Data
Jim
Mary
Mike
Paul
Sam
Mary
Jim
Jim
Judy
Mike
Results
1. Jim 3
2. Mary 2
3. Mike 2
Example:
Data
Jim
Mary
Mike
Paul
Sam
Mary
Jim
Jim
Judy
Mike
Results
1. Jim 3
2. Mary 2
3. Mike 2