Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 05-17-2015, 11:03 AM
michael_1962 michael_1962 is offline MODE function excluding hidden rows Windows 7 64bit MODE function excluding hidden rows Office 2007
Novice
MODE function excluding hidden rows
 
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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
MODE function excluding hidden rows 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
MODE function excluding hidden rows how to view hidden rows gsrikanth Excel 10 01-27-2012 05:29 AM
MODE function excluding hidden rows hidden rows gsrikanth Excel 5 01-19-2012 02:40 PM
MODE function excluding hidden rows 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 12:05 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft