hedgeman50
Board Regular
- Joined
- Sep 20, 2002
- Messages
- 76
Here's the setup: I have data in column A (A5:A64, to be exact). Column A has negative numbers and multiple zero values. In cell E19, I have: =MIN(A5:A64).
I need for cell E20 to be able to count back from the cell that had the min value from the equation in E19 (cell A28 in this case, but the cell could change when data is updated, so I don't want to hard-code that cell) to the most recent zero value (counting backward). I also need for the next cell, E21, to be a count of the number of cells after the result from the equation in E19 until a value of zero is reached (same as previous equation but counting forward instead of backward).
The equation would look something like this (but using correct formulas):
=count backward from (cell result in E19) until 0.00 is reached
How can this be done?
Thanks,
Hedgeman50
I need for cell E20 to be able to count back from the cell that had the min value from the equation in E19 (cell A28 in this case, but the cell could change when data is updated, so I don't want to hard-code that cell) to the most recent zero value (counting backward). I also need for the next cell, E21, to be a count of the number of cells after the result from the equation in E19 until a value of zero is reached (same as previous equation but counting forward instead of backward).
The equation would look something like this (but using correct formulas):
=count backward from (cell result in E19) until 0.00 is reached
How can this be done?
Thanks,
Hedgeman50