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)+1ROWS(montasks)-
COUNTBLANK(montasks),"",INDIRECT(ADDRESS(SMALL(
(IF(montasks<"",ROW(montasks),ROW()+ROWS(montasks ))),
ROW()-ROW(noblanksrange)+1),COLUMN(montasks),4)))}

any ideas gratefully received!

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

"Atishoo" wrote:

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)+1ROWS(montasks)-
COUNTBLANK(montasks),"",INDIRECT(ADDRESS(SMALL(
(IF(montasks<"",ROW(montasks),ROW()+ROWS(montasks ))),
ROW()-ROW(noblanksrange)+1),COLUMN(montasks),4)))}

any ideas gratefully received!