MODE function excluding hidden rows

		Microsoft Office Forums > Microsoft Excel > Excel
MODE function excluding hidden rows

FAQ

Thread Tools

Display Modes

05-17-2015, 11:03 AM

michael_1962 michael_1962 is offline

Windows 7 64bit MODE function excluding hidden rows

Office 2007

Novice

Join Date: May 2015

Posts: 2

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

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
VBA to keep hidden rows hidden when filtering	tectonicseer	Excel Programming	1	07-27-2014 11:54 AM
a function that deletes all rows with no value in a certain column?	dunndealpr	Excel	2	06-08-2013 06:50 AM
how to view hidden rows	gsrikanth	Excel	10	01-27-2012 05:29 AM
hidden rows	gsrikanth	Excel	5	01-19-2012 02:40 PM
Word won't come back to normal mode from proofreading mode	prg4hire	Word	2	09-25-2010 09:46 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:22 PM.