removing blanks from range (mr Pearson)

[Atishoo]

Hi all
Am trying to use one of Pearsons worksheet formula to return a new column
(noblanksrange) without the blanks in the original column (montasks).
Something is not quite right Im jsut getting 0 in the first two columns and
nothing more?
(oh and i am remebering to use ctrl shift enter and the ranges are of equal
length)

{=IF(ROW()-ROW(noblanksrange)+1>ROWS(montasks)-
COUNTBLANK(montasks),"",INDIRECT(ADDRESS(SMALL(
(IF(montasks<>"",ROW(montasks),ROW()+ROWS(montasks))),
ROW()-ROW(noblanksrange)+1),COLUMN(montasks),4)))}

any ideas gratefully received!

 

[Atishoo]

SOK have got it the two named ranges were on seperate sheets have copied
range onto one sheet problem solved!