PDA

View Full Version : Solved: MODE function to display the most common value present in a particular range of cells



parttime_guy
08-04-2011, 08:16 AM
Hi

Can MODE be used in a single column with MODE results changing on various multiple filters selections.:think:

Thanks & Best Regards

Bob Phillips
08-04-2011, 08:39 AM
You mean MODE on only the visible cells? What Excel version do you have?

parttime_guy
08-04-2011, 07:33 PM
I want to display the most common value present in filtered range

Sample wks attached.

Best regards