I need to identify the max fvalue in a range, then the enxt highest value, then the next highest, etc. in order to input elsewhere in a file....
for example: 2400 4150 3900 6300
Is there a simple method or formual to use?
Many thanks.
I need to identify the max fvalue in a range, then the enxt highest value, then the next highest, etc. in order to input elsewhere in a file....
for example: 2400 4150 3900 6300
Is there a simple method or formual to use?
Many thanks.
=Large(A$2:A$40, 1)
will return the highest number in the range A2:A40. Modify the last value to 2, to return the second largest etc.