Max with similiar values within the range

[Darin Kramer]

Howdie,

A1 = 4
B1 = 3
C1 = 4
D1 = 2
E1 = 3
F1 = 1

From the above I want to extract the three MAX scores, ie the answer
would be 4,4,3 (preferably to be displayed in different cells)The Max
number is 4. Min number is 0.
Any ideas?

I can find the first max, but when trying to eliminate that item from
the population ie(a1-max) I get stuck because both a1-max and c1-max = 0
and thus would be eliminated from my population so my formulae cant deal
with two similar scores, which unfortunately there are.

Thanks guys

D

*** Sent via Developersdex http://www.developersdex.com ***

 

[Neil]

Darin,

In cell A2 put in formula
=LARGE(A1:F1,{1})
cell A3
=LARGE(A1:F1,{2})
cell A4
=LARGE(A1:F1,{3})

Regards
Neil

 

[Darin Kramer]

Thanks so much - works brilliantly!!!

*** Sent via Developersdex http://www.developersdex.com ***