Microsoft Office Forums - View Single Post - for visible cells (filtered), how find value lowest than 4.00 and return the cell number

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

View Single Post

Old

08-02-2017, 03:17 PM

Logit

Logit is offline

Logit uses Windows 10

Windows 10 Logit uses Office 2007

Logit uses Office 2007

Office 2007

Expert

Join Date: Jan 2017

Posts: 533

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