I'm analyzing a large data set with about 100 lists, and I'd like a quick way of identifying the Top 10 within each list. Each list has company names in one column and whole numbers in the adjacent column, with occasional duplicate numbers. For instance:
Company A - 140
Company B - 152
Company C - 140
etc.
I came across this explanation of using Large, Index, and Match to create a Top 10 list, but it doesn't work when the list has duplicate values. http://www.excel-user.com/2011/02/la...lues-from.html
Do you guys know of a way to do this if your list has duplicate values?
Bookmarks