Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
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 Office 2007
Expert
 
Join Date: Jan 2017
Posts: 591
Logit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the roughLogit 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
 



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
for visible cells (filtered), how find value lowest than 4.00 and return the cell number 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 12:17 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft