Microsoft Excel - how to return 2 highest values from a row with not ranked, not unique values

Asked By Ewa P on 27-Sep-13 08:44 AM
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
Harry Boughen replied to Ewa P on 27-Sep-13 04:06 PM
Hello Ewa
=MAX(A2:H2) will give you the largest.
=LARGE(A2:H2,2) will give you the second largest (or equal largest if there are duplicates in first place).
Regards
Harry