Hey, I'm new here and on a short timeline so please excuse the lack of an intro post. I'll post one later because I plan to come back for more help in the future.
Any how I'm working on a list like this:
Company 1 14
Company 2 5
Company 3 10
Company 4 6
Company 5 10
I'm trying to get it to list the companies in order from greatest to least. How ever there are two companies with the same value, so when it gives me the data it goes:
Company 1
Company 3
Company 3
Company 4
Company 5
Here is the code I'm using:
=INDEX(A1:A5,MATCH(LARGE(B1:B5,1),B1:B5,0),1)
=INDEX(A1:A5,MATCH(LARGE(B1:B5,2),B1:B5,0),1)
=INDEX(A1:A5,MATCH(LARGE(B1:B5,3),B1:B5,0),1)
=INDEX(A1:A5,MATCH(LARGE(B1:B5,4),B1:B5,0),1)
=INDEX(A1:A5,MATCH(LARGE(B1:B5,5),B1:B5,0),1)
Respectively.
Is there a way to get excel to exclude the previous result or return the next value?
Thank you very much
-Yoshi
Bookmarks