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

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)

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

No I don't know why.

The 105 in the formula is supposed to overlook the hidden cells

Attached Files

MIN and Row.xlsx (9.7 KB, 9 views)

Isn't he formula supposed to be
=SUBTOTAL(105,A1:A44)
and the row
=MATCH(SUBTOTAL(105,A1:A44),A1:A44,0)

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

As these are formula solutions I will move the thread to the proper forum

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

https://www.excelforum.com/excel-for...ll-number.html