I got help finding top 5 in two columns. Need now sorting out from one column. See attached xls.
I got out the top 5 values, though now I need to pick up corresponding lines to these values.
SEALPINO
I got help finding top 5 in two columns. Need now sorting out from one column. See attached xls.
I got out the top 5 values, though now I need to pick up corresponding lines to these values.
SEALPINO
Why dont you just replace that elaborate formula in M22:M26 with this?
=LARGE(M$3:M$18,1)
as you copy the formula down keep increasing the 1 by 1. So
=LARGE(M$3:M$18,1)
=LARGE(M$3:M$18,2)
etc
Then use this to find the name
in L22
=OFFSET(M$3,MATCH(M22,M$3:M$18,0)-1,-1)
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks