Microsoft Office Forums - View Single Post - MODE function excluding hidden rows

Thread: MODE function excluding hidden rows

View Single Post

Old

05-17-2015, 11:03 AM

michael_1962 michael_1962 is offline

michael_1962 is offline

michael_1962 uses Windows 7 64bit

Windows 7 64bit michael_1962 uses Office 2007

michael_1962 uses Office 2007

Office 2007

Novice

The original poster

Join Date: May 2015

Posts: 2

michael_1962 is on a distinguished road

Default

MODE function excluding hidden rows

How do I make this Mode.sngl function to work only for visible rows?

=MODE.SNGL(IF($I$2:$I$5701=P2, IF($J$2:$J$5701=Q2,$L$2:$L$5701)))

I will be grateful for your help

Thanks

Reply With Quote