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

Microsoft Office Forums

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

Prev

Previous Post

Next Post

Next

#2

Old

08-02-2017, 03:17 PM

Logit

Logit is offline

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

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

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

Logit is a jewel in the rough

Logit is a jewel in the rough

Logit is a jewel in the rough

Logit is a jewel in the rough

Default

https://exceljet.net/formula/sum-vis...-filtered-list

https://exceljet.net/excel-functions...total-function

Smallest # =MIN(105,A1:A44)

Row # =MATCH(MIN(105,A1:A44),A1:A44,0)

Reply With Quote

« Previous Thread | Next Thread »

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 01:47 PM.