View Single Post
  #1   Report Post  
kafoury123
 
Posts: n/a
Default 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