Home |
Search |
Today's Posts |
#1
|
|||
|
|||
getting rid of zero values in a column
i have a set of data on a column that i`ll use to plot on a graph and find a
trendline for its behaviour...problem is: there is zero values in some cells that were not calculated... i want to copy this data in a new column getting rid of cells with zero value because it results in a wrong trendline...how can i do this?please help this is an example of what i mean: 1 1 3 3 4 4 0 6 6 3 3 1 0 0 0 1 |
#2
|
|||
|
|||
One of the simpler ways is to hide the rows for the cells that have zeros and
then plot the graph. "kafoury123" wrote: i have a set of data on a column that i`ll use to plot on a graph and find a trendline for its behaviour...problem is: there is zero values in some cells that were not calculated... i want to copy this data in a new column getting rid of cells with zero value because it results in a wrong trendline...how can i do this?please help this is an example of what i mean: 1 1 3 3 4 4 0 6 6 3 3 1 0 0 0 1 |
#3
|
|||
|
|||
how can i ommit the zero values cells automaticaly..not manualy??
"Raj" wrote: One of the simpler ways is to hide the rows for the cells that have zeros and then plot the graph. "kafoury123" wrote: i have a set of data on a column that i`ll use to plot on a graph and find a trendline for its behaviour...problem is: there is zero values in some cells that were not calculated... i want to copy this data in a new column getting rid of cells with zero value because it results in a wrong trendline...how can i do this?please help this is an example of what i mean: 1 1 3 3 4 4 0 6 6 3 3 1 0 0 0 1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Column Chart with 2 values in each column | Charts and Charting in Excel | |||
Formula to compare multiple rows values based on another column? | Excel Worksheet Functions | |||
How sum values in column B using values in column A as the conditi | Excel Worksheet Functions | |||
Removing duplicate values in a column | Excel Worksheet Functions | |||
Can you average data in 1 column based on a range of values in another? | Excel Worksheet Functions |