I know there's a simple solution to this, but I am too green to figure it out.
Basically, I have this range:
And I want to in a new cell a function to find the highest two based on Row 3 to look like this
Basically, I have this range:
9 | 6 | 3 | 1 | 4 | 2 | 8 | 5 | 7 |
A | B | C | D | E | F | G | H | I |
24 | 13 | 15 | 18 | 10 | 13 | 15 | 20 | 16 |
And I want to in a new cell a function to find the highest two based on Row 3 to look like this
9 | 5 |
A | H |
24 | 20 |