=MODE(IF(A1:A9<0,A1:A9,"")) entered as an array formula
(Control-Shift-Enter)
--
David Biddulph

"Rothman" wrote in message
...
I've done some searching; I hope this hasn't been answered elsewhere.

I have a column of data where I want to calculate the modes while ignoring
zeroes that are in the table. So:

Column 1
1
1
1
0
0
0
0
2
3

Mode w/o Zeroes = 1

Any suggestions?