Most Common Number NOT Zero

[BradB]

I'm looking for a way to list the most common number in a given list. Normally, I would use the MODE function. Well, Zero as it turns out IS the most common among a series of numbers. I need Zero to be in the data series, but I want the most common Not including zero. Is there an easy way to do this?

Example
0
1
2
2
0
0

I want the mode (most common) to be 2 not 0.

Thanks,
Bradb

 

[BradB]

I think I figured it. I created a RunningTotal With the Summary as Mode, and Evaluate: Formula<>0, Reset on Date.

Why do they call it a running total when you can do Soooo many things with it?