Hi
Can MODE be used in a single column with MODE results changing on various multiple filters selections.
Thanks & Best Regards
Hi
Can MODE be used in a single column with MODE results changing on various multiple filters selections.
Thanks & Best Regards
You mean MODE on only the visible cells? What Excel version do you have?
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
I want to display the most common value present in filtered range
Sample wks attached.
Best regards