Quote:
Originally Posted by frankjh19701
By the way, I don't how to do this in VB. If you can show me the steps, I can follow. |
--------------------------------------------------------------------------
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.