SMALL Function

  • Thread starter Thread starter ToMD
  • Start date Start date
T

ToMD

I use the following to display the first 5 smallest
numbers in a column (Gross scores in golf competition)

SMALL(Medal!F$6:F$705,1)
SMALL(Medal!F$6:F$705,2)
SMALL(Medal!F$6:F$705,3)
SMALL(Medal!F$6:F$705,4)
SMALL(Medal!F$6:F$705,5)

If the sheet is blank (e.g. templat yet to be completed
with results) then each of these cells contains #NUM!.
I'd like these cells to be appear empty as well i.e no
#NUM! displayed. I thought I could use.......
..
..
=IF(Medal!F$6:F$705="","",SMALL(Medal!F$6:F$705,3))
..
..
Whilt this does give a visual blank/empty cell, when
results are entered, it still remains blank and doesn't
show for example 3rd lowest number. How can I achieve
what I'm looking for. I'm sure it's staring me in the
face but currently can't see it ?1?

Just as an asise, sometimes it works and sometimes it
doesn't and this confuses me.

Regards

Tom
 
Hi
try something like
=IF(ISERROR(SMALL(Medal!F$6:F$705,1)),"",SMALL(Medal!F$6:F$705,1))
 
Frank,

Thanks. I tried, it worked. Very grateful for your
quick response. If I could only of thought of the word
Error it might of clicked, but then, that's the beauty of
these forums, there's always someone on the ball with
their finger on the pulse. Once again, many thanks

Tom
 
Back
Top