Help with Offset

[kazoo]

I am using offset to copy some data from another worksheet. Unfortunately,
the number of rows varies from column to column.

If I drag the cursor down, it displays "0" in the cells that do not have any
data from the original worksheet. Is there a way to not display the "0"? I
want to plot this data so it doesn't work to just reformat the cell to not
display the "0". It also isn't an option to just drag the cursor down to a
certain point on each column since my data is dynamically changing.

Thanks!

 

[Bob Phillips]

Test the source for blank,

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

 

[Sheeloo]

One solution:

You can get blank cell if you put an IF around your formula

IF(your formula=0,your formula,"")

this will put a blank in the cell where you are getting 0 now.

 

[Sheeloo]

Replace = with <> in my formula
Sorry about the typo

 

[kazoo]

Thanks, it worked great!

Test the source for blank,

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

--
__________________________________
HTH

Bob