On Wed, 17 Dec 2008 22:26:00 -0800, Eric
wrote:

Does anyone have any suggestions on how to determine the value?
There is a list of value under column A
36,36,42,42,42,48,48,48,47,47,25,25,25,25
I would like to determine the largest value under the lists, which is 48 in
cell B1
I would like to determine the second largest value under the lists, which is
not equal to 48. It should return 47 in cell B2
I would like to determine the thrid largest value under the lists, which is
not equal to largest and second largest. It should return 42 in cell B3
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric

Enter this formula in B1, and fill down as far as required.

Vals is a defined name with this formula:

=OFFSET(Sheet1!$A$1,0,0,COUNT(Sheet1!$A:$A))

(or it could be an absolute reference to the range that contains values)

=LARGE(IF(FREQUENCY(Vals,Vals)0,Vals),ROWS($1:1))

So as not to return errors, you could use one of these formulas:

Excel 2007:

=IFERROR(LARGE(IF(FREQUENCY(Vals,Vals)0,Vals),ROW S($1:1)),"")

Prior versions:

=IF(ISERR(LARGE(IF(FREQUENCY(Vals,Vals)0,Vals),RO WS($1:1))),"",
LARGE(IF(FREQUENCY(Vals,Vals)0,Vals),ROWS($1:1)))
--ron