Thread: Finding 2nd smallest number in range
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rachel7 Rachel7 is offline
external usenet poster
  
Posts: 10
Default Finding 2nd smallest number in range
I need to return the 2nd smallest number in a range of cells, but the range
contains empty cells, multiple values & zero values. I need to ignore the
empty cells, multiple values & zero values - can this be done?
Reply With QuoteReply With Quote