Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |