Mode function limit

[Lightfoot]

We have several columns of data, each with nearly 2,000 rows. The data
ranges from 1 to 50 and we need to know the mode for each column.

Is this possible? The MODE function seems to be limited to only 30.
How can we get around this limit?

Thanks.

 

[Jan Karel Pieterse]

Hi,

Certain XL functions accept "just" 30 arguments. But a
range of cells is considered a single argument, so:

=MODE(A2:A2000) should work for you.

If you need the MODE for non-contiguous cells, more
arguments are needed:

=MODE(A2:A2000,C2:C2000,E2:E2000)

Knowing this, it is very unlikely you would exceed the 30
argument limit.

Regards,

Jan Karel Pieterse
Excel TA/MVP