Yes, that works. However, what do I do if I have duplicates? How can I show them all? I have two for Number one (Largest Value) but it's only showing the same number twice - the first one in the list not the second one.
Quote:
Originally Posted by Mazzaropi
--------------------------------------------------------------------------
Dear Frankjh19701, Good Morning.
Your example:
____A________B___C______D_____________E
1___2.35650___1___blank__=FORMULA 1___=FORMULA 2
2___2.45690___2___blank__=FORMULA 1___=FORMULA 2
3___2.53690___3___blank__=FORMULA 1___=FORMULA 2
4___2.11547___4
5___2.66354___5
DO THIS:
FORMULA 1
D1 -- =LARGE(A:A,1)
D2 -- =LARGE(A:A,2)
D3 -- =LARGE(A:A,3)
FORMULA 2
E1 -- =INDEX(B:B,MATCH(D1,A:A,0))
E2 -- =INDEX(B:B,MATCH(D2,A:A,0))
E3 -- =INDEX(B:B,MATCH(D3,A:A,0))
Try this one.
Please, tell me if it worked for you.
Feel free to ask anything about it.
Have a nice day.
|