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

Thread: MODE function excluding hidden rows

View Single Post

Old

05-21-2015, 10:09 PM

excelledsoftware excelledsoftware is offline

excelledsoftware is offline

excelledsoftware uses Windows 8

Windows 8

excelledsoftware uses Office 2003

Office 2003

IT Specialist

Join Date: Jan 2012

Location: Utah

Posts: 455

excelledsoftware will become famous soon enough

Default

Besides autofilters or VBA I am not aware of a way to have a formula determine if a row is hidden. With an autofilter you can fill the formula in and it will ignore the hidden ones but VBA may be a better bet for you.

Reply With Quote