Thread: "Small"
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
MartinW MartinW is offline
external usenet poster
 
Posts: 860
Default "Small"

Yes Peo. but in the given example =SMALL(S1:S5,3)
if 1 or 2 of those entries are text it will return a false answer
and if more than 2 of those entries are text it will return a #num error
as there is not enough data to produce the third smallest.

Regards
Martin