Eliminating zero values from a column

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

you could maybe add an if statement to the formula you have calculating the column so that =if(**your formula**=0," ","**your formula**)- or post the formula and we will amend

Let me give a little bit more information because maybe putting the values into a column isn't the way I should be going. What the worksheet is is a random treasure generator for D&D. The user has the option of where they want to select from all available treasure, or specify if they only want it to select from certain ones (ie sword, armor, etc). The way I have it set up is with a Yes/No cell for each option. I also have a cell ("Selecter Cell") that randomly selects one option for each choice (ie there's a list of 50 swords and it picks one and puts it in that cell). Now what I'm trying to do is get it to select one from that list of "Selecter Cells". What I can't figure out is how to get it to not pick one from one of the options that is set to No. What I was trying to do was have the "Selecter Cell" return 0 if they choose No for that item type, and then eliminate all the 0's and select from there but I'm not getting anywhere trying to do that. Any suggestions? If I can get a list of the "Selecter Cells" that are not 0 I can get it from there, but it's getting to that lists that is stopping me.
With All Due Respect,
Errabal