second highest digit

[Pivotrend]

A1=1
A2=2
A3=3
A4=4
A5=5
A6=6
A7=7
A8=8

i know that =MAX(A1:A8) will give me "8" but i need a formula tha
retrieves the second highest digit which is "7"
& third highest digit which is "6"

any body know how

 

[Paul B]

Pivotrend, use large, like this =LARGE(A1:A8,2) =LARGE(A1:A8,3)
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 2003
** remove news from my email address to reply by email **

 

[BenjieLop]

For the second highest, use this =large($A$2:$A$8,2)
and for the third highest, =large($A$2:$A$8,3)

 

[Guest]

hi,
=MAX(A1:A8)-1 = 7
=MAX(A1:A8)-2 = 6
=MAX(A1:A8)-3 = 5
ect.

 

[BenjieLop]

CORRECTION (ON THE RANGE

2nd highest: =large($A$1:$A$8,2)
3rd highest: =large9$A$1:$A$8,3)

 

[RagDyeR]

Have you tried this with other numbers besides 1 to 8?

--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------

hi,
=MAX(A1:A8)-1 = 7
=MAX(A1:A8)-2 = 6
=MAX(A1:A8)-3 = 5
ect.