for visible cells (filtered), how find value lowest than 4.00 and return the cell number

		Microsoft Office Forums > Microsoft Excel > Excel
for visible cells (filtered), how find value lowest than 4.00 and return the cell number

08-02-2017, 08:30 PM

Logit

Windows 10 for visible cells (filtered), how find value lowest than 4.00 and return the cell number

Office 2007

Expert

Join Date: Jan 2017

Posts: 591

No I don't know why.

The 105 in the formula is supposed to overlook the hidden cells

Attached Files

MIN and Row.xlsx (9.7 KB, 9 views)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
VBA color of visible gridlines of tables word (with some merged cells in first rows)	Alvaro.passi	Word VBA	0	07-18-2017 09:11 AM
What formula can I use to find the lowest cell in a column that has a value in it?	EddyWD	Excel	3	04-20-2016 09:29 PM
Find text within cell and return column and row title next to the name on a new sheet.	tanyabowring@live.co.uk	Excel Programming	2	03-26-2015 01:48 AM
In Excel 2007-After Selecting Visibe Cells-How do I "Copy to Visible cells" Only	mag	Excel	0	10-28-2012 08:04 PM
text not visible in a number of emails	jbrad	Outlook	0	07-06-2010 03:44 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:40 PM.