Find the BEST TWO VALUES from 5 cells
Dear Friends,
I am to find out TOP TWO VALUES OF 5 VALUES in a row.
For Example:
From the above D1 & F1 are having top two values and hence that should be added and given in J1.D1 E1 F1 G1 H1 J1 6 3 7 5 4 (13)
Can anyone help me to find the solution, please?
Last edited by acsishere; 03-12-2011 at 12:58 AM.
Good friends are hard to find, harder to leave, and impossible to forget.
acsishere.
j1 = large(d1:h1,1)+large(d1:h1,2)
One test is worth a thousand opinions.
Dear Mr. Marvin,
Excellent. Thank you very much for your solution.
Thanks.
Good friends are hard to find, harder to leave, and impossible to forget.
acsishere.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks