Mode

S

Skin

Using 2004 11.2, Tiger

How can I use MODE in a filtered database. Each time I filter I would Like
to see the most common denominator (value only) in a column. For other:
sum,average,count and max I use subtotal. I am Stymied with this one!
Maybe another function?
Regards Paul.
 
D

Domenic

Try...

=MODE(IF(SUBTOTAL(3,OFFSET(Range,ROW(Range)-MIN(ROW(Range)),0,1)),Range))

....confirmed with CONTROL+SHIFT+ENTER, not just ENTER.

Hope this helps!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Column Sums & Auto Filtering 1
Trying to count returned cells from a filter 2
need help on either doing a loop and counting specific values orusing subtotal function 2
subtotal excluding spaces "" 0
SUMPRODUCT formula is summing text and I want it to stop doing that 2
Sum after Filter, Count after Fliter 2
Creating Calculations after Autofilter On 3
histogram dynamic bin count 0

Top