Please see the attached spreadsheet. I have a list of 1268 names, some of them appearing more than once. I want to know how many times each name appears on the list, and then rank the names by the number of times they're listed. How do I do this?
Thank you in advance for your help!
In cell B4 use the formula:
=COUNTIF($A$4:$A$1272,A4) and copy down.
Then sort on column 'B' values largest to smallest
EllBol
Last edited by EllBol; 03-06-2012 at 03:04 PM.
Outstanding. Thanks EllBol, that's exactly what I needed!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks