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, 06:33 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

Thanks for answering.

I tried exactly what you suggested.
Applied both formulas
Smallest # =MIN(105,A1:A44) = 1.90
Row # =MATCH(MIN(105,A1:A44),A1:A44,0) = 8

But when i try to hide a few lines like the line that has 1.90, the result is the same
Smallest # =MIN(105,A1:A44) = 1.90
Row # =MATCH(MIN(105,A1:A44),A1:A44,0) = 8

Any idea why?

thanks in advance

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