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