Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
#NUM!
If have the following in cells C21 thru' C25 on a
worksheet =SMALL(Medal!F$5:F$50,1) =SMALL(Medal!F$5:F$50,2) =SMALL(Medal!F$5:F$50,3) =SMALL(Medal!F$5:F$50,4) =SMALL(Medal!F$5:F$50,5) Prior to any entries appearing in the Medal worksheet, C21 thru'C25 contain #NUM!. I don't want these to be shown. What addition to the code above needs to be made such that the cells will initially appear blank |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
#NUM!
Hi
use something like =IF(ISERROR(SMALL(Medal!F$5:F$50,1)),"",SMALL(Meda l!F$5:F$50,1)) -- Regards Frank Kabel Frankfurt, Germany TomD wrote: If have the following in cells C21 thru' C25 on a worksheet =SMALL(Medal!F$5:F$50,1) =SMALL(Medal!F$5:F$50,2) =SMALL(Medal!F$5:F$50,3) =SMALL(Medal!F$5:F$50,4) =SMALL(Medal!F$5:F$50,5) Prior to any entries appearing in the Medal worksheet, C21 thru'C25 contain #NUM!. I don't want these to be shown. What addition to the code above needs to be made such that the cells will initially appear blank |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
#NUM!
Frank,
Thanks. Works as required. Tom -----Original Message----- Hi use something like =IF(ISERROR(SMALL(Medal!F$5:F$50,1)),"",SMALL(Med al! F$5:F$50,1)) -- Regards Frank Kabel Frankfurt, Germany TomD wrote: If have the following in cells C21 thru' C25 on a worksheet =SMALL(Medal!F$5:F$50,1) =SMALL(Medal!F$5:F$50,2) =SMALL(Medal!F$5:F$50,3) =SMALL(Medal!F$5:F$50,4) =SMALL(Medal!F$5:F$50,5) Prior to any entries appearing in the Medal worksheet, C21 thru'C25 contain #NUM!. I don't want these to be shown. What addition to the code above needs to be made such that the cells will initially appear blank . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|