View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Lori Lori is offline
external usenet poster
 
Posts: 340
Default 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