Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
offset | Excel Worksheet Functions | |||
Compare Cell Values, Offset(-1,0), Offset(-1,-1), and xlFillDefaul | Excel Worksheet Functions | |||
Offset Help | Excel Worksheet Functions | |||
Offset. | Excel Worksheet Functions | |||
=offset ??? | Excel Worksheet Functions |