Hi,
I need excel to return 2 highest values from a row (not highligh, that's just an example)
the values are not in order, and not unique: in example below in row 2 I'd expect to return 35 twice (not 35 and 30)
I tried workign with IF(LARGE(RANK(A2,A3:H3,0)=1,1) but end up with more than 2 values returned
Thank you for looking
Ewa
| a |
b |
c |
d |
e |
f |
g |
h |
| 10 |
20 |
30 |
35 |
30 |
20 |
20 |
2 |
| 35 |
30 |
35 |
30 |
20 |
20 |
2 |
5 |
| 50 |
40 |
35 |
30 |
20 |
20 |
2 |
5 |
|
|
|
|
|
|
|
|