I am trying to write a formula that will read only the data values in a column and ignore the zero values. Is this possible with a formula or is VBA the only way to do it. Here is a sample of my sheet:
I am trying to calculate the net change between dates that have actual values entered. The values are read in from a database sheet so sometimes there will not be data for a given date, hence the zero values. I am using a VLOOKUP to get all the values for the DATA and AVERAGE columns, if that helps any.
I've been wrestling with this one for a while now....
Book1 | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | Date | DATA | AVERAGE | Settlement (ft) | NetChange (ft.) | ||
2 | 11/10/2003 | 75.07 | 75.25 | -0.18 | |||
3 | 12/19/2003 | 75.05 | 75.24 | -0.19 | -0.0125 | ||
4 | 1/2/2004 | 0 | 0.00 | 0.00 | |||
5 | 1/9/2004 | 0 | 0.00 | 0.00 | |||
6 | 1/30/2004 | 75.03 | 75.24 | -0.21 | -0.02 | ||
TESTING |
I am trying to calculate the net change between dates that have actual values entered. The values are read in from a database sheet so sometimes there will not be data for a given date, hence the zero values. I am using a VLOOKUP to get all the values for the DATA and AVERAGE columns, if that helps any.
I've been wrestling with this one for a while now....