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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.