Morning all,
The problem I'm having is I can't figure out a way to condense down a column to show only the values in the column that are not zero. The values in the column are calculated from other cells in the worksheet so they can change from zero to non-zero and back again. I tried applying filters but they only seem to work on the current value of the cell and don't update if the cell value is changed. This is a sheet that I have to distribute to other people so just re-applying the filter whenever it needs to be recalculated isn't an option as some of these people that would be beyond their capabilities with a computer. I'm looking for something that is done automatically with formulas. Macros aren't really an option either. Any suggestions?
With All Due Respect,
Errabal