suppressing blanks

  • Thread starter Thread starter Iain Wicks
  • Start date Start date
I

Iain Wicks

Hi,
I need help with a simple suppression issue.
On worksheet1, in cell A1, I am displaying the contents of
worksheet2 cell A1 by using the expression '=(sheet2!A1)' .

I am doing this for all cells in the A column down to
number 20. But I want to get rid of blanks.
e.g. if sheet2 A1 and A3 are populated but A2 is not
populated I do not want to see a gap on Sheet1, I want to
just see a list of the populated ones.

I hope this makes sense.

Regards
Iain
 
Iain,

=IF(Sheet2!A1="","",Sheet2!A1)

or

=IF(ISBLANK(Sheet2!A1)=TRUE,"",Sheet2!A1)

PC
 
Back
Top