Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
offset
I wonder if somebody can help me.
I have data in one spreadhseet and I need to use a formula ( I belive it's offset) to see a results of the analysis in the new spreadsheet. I need to see same data, but only ones without 0's in one of the column. If there is 0 I don't need to have it in a new spreadhseet. Thanks for help |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
offset
It's not clear what you're asking. Give some more information about the data
in question. Dave -- Brevity is the soul of wit. "Eva" wrote: I wonder if somebody can help me. I have data in one spreadhseet and I need to use a formula ( I belive it's offset) to see a results of the analysis in the new spreadsheet. I need to see same data, but only ones without 0's in one of the column. If there is 0 I don't need to have it in a new spreadhseet. Thanks for help |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
offset
ok
There is an example sheet1 data: COLUMN A COLUMN B COLUMN C 1 a 12 2 b 0 3 c 14 I need to get a results in sheet2 as follows: COLUMN A COLUMN B COLUMN C 1 a 12 3 c 14 All rows where is 0 in column C should be removed from sheet2. Thanks Eva "Dave F" wrote: It's not clear what you're asking. Give some more information about the data in question. Dave -- Brevity is the soul of wit. "Eva" wrote: I wonder if somebody can help me. I have data in one spreadhseet and I need to use a formula ( I belive it's offset) to see a results of the analysis in the new spreadsheet. I need to see same data, but only ones without 0's in one of the column. If there is 0 I don't need to have it in a new spreadhseet. Thanks for help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Use of Offset function in array formula | Excel Worksheet Functions | |||
How to offset cell value from thick border lines? | Excel Discussion (Misc queries) | |||
Macro question | Excel Worksheet Functions | |||
Offset Function works in cell, not in named range | Excel Worksheet Functions | |||
Question for use of offset and range | Excel Worksheet Functions |