How to determine the value from a list?
Try array-entered (ctrl+shift+enter to evaluate):
=MIN(IF(A1:A6MIN(A1:A6),A1:A6))
On 22 May, 08:25, Eric wrote:
Does anyone have any suggestions on how to determine the value from a list?
22,22,25,27,27,28
I would like to determine the second smallest value, but skip checking the
repeated one, such as in this case, I should select 25 and skip 22 because
there are repeated 22 from the list.
Does anyone have any suggestions?
Thank you in advance
Eric
|