how do i ignore a number when using MODE function?

D

Dev4me

Hi

I have a list of numbers that I want to find the MODE in:

0
0
1
2
0
0
3
3
2
2
2
0
0

But I want to be able to ignore the Zeros
How do i go about doing this so the mode function gives me the #2 only
Thank you
 
B

Bob Phillips

=MODE(IF(A1:A20<>0,A1:A20))

which is an array formula, so commit with Ctrl-Shift-Enter

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
B

Biff

Hi!

Entered as an array using the key combo of CTRL,SHIFT,ENTER:

=MODE(IF(A1:A15<>0,A1:A15))

Biff
 
D

Dev4me

Thanks guys it worked!

What does it mean by entering as Array formula with Ctrl shift Enter
 
D

Dev4me

Thanks guys it worked!

What does it mean by entering as Array formula with Ctrl shift Enter?
 
B

Bob Phillips

It means that when you enter the formula, don't just hit the Enter key, but
press Ctrl-Shift-Enter together.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top