Return Cell Address of the min() formula result

Hi,

I have this range B1707:MB2045 which contains formulas in all cells.

I used this formula to find the smallest value, expect zero.

=MIN(IF(B1707:MB2045>0,B1707:MB2045))

How do I find the address of the cell in the result?

hi ciprian, maybe something like this:

Formula:

=ADDRESS(MIN(IF(B1707:MB2045=MIN(IF(B1707:MB2045>0,B1707:MB2045)),ROW(B1707:MB2045))),MIN(IF(B1707:MB2045=MIN(IF(B1707:MB2045>0,B1707:MB2045)),COLUMN(B1707:MB2045))))

array formula still

Hi benishiryo,

The result points to a cell that has a value of 0 and it's not even the first one with 0 value in the range.

Edit: I added an example