Source numbers in A1 down
In B1: =IF(A1="","",IF(COUNTIF($A$1:A1,A1)1,"",A1))
In C1: =IF(ROW()COUNT(B:B),"",LARGE(B:B,ROW()))
Copy B1:C1 down to cover the max expected extent of source data. Minimize
col B. Col C will return exactly what you seek.

P/s: Don't you think its high time you changed the subject line to better
reflect each of your queries. As-is its becoming a bit of a monotone.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:21,000 Files:370 Subscribers:66
xdemechanik
---
"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