Help with Offset
 

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!

Help with Offset
 

Test the source for blank,

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

--
__________________________________
HTH

Bob

"kazoo" wrote in message
...
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!

Help with Offset
 

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.

"kazoo" wrote:

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!

Help with Offset
 

Replace = with < in my formula
Sorry about the typo

"kazoo" wrote:

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!

Help with Offset
 

Thanks, it worked great!

"Bob Phillips" wrote:

Test the source for blank,

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

--
__________________________________
HTH

Bob

"kazoo" wrote in message
...
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!