Search row of numbers, find highest value.
I have a spreadsheet like this:
1 2 3 4 Total
A 5 6 7 8 26
B 1 2 3 4 10
I am trying to find a function that will search the row (let's say Row 'A')
and return the highest value (8)...and then the 2nd highest value (7). Row
B's results are '4', and '3', of course.
Can someone please help me find the function I should use for this? Thank
you in advance.
|