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

FAQ

Thread Tools

Display Modes

08-02-2017, 02:26 PM

murfy69

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

Office 2016

Novice

Join Date: Aug 2017

Posts: 2

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

Hi All,
i have a table with with a column that has numbers like:
10
9.22
7.33
5.44
4.67
3.12
2.10

1.90
and i want to be able to find the lower value bigger than 4 and to do that i can use the formula:
=MIN(IF(A2:A8>4,A2:A8))
But i am having two issues that the moment:
1- how can i make this formula work only for unhidden cells?
2- how can i return the line/column of that cell?

Thanks and Advance.
DC

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