"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
|