Min()
 

hi,

I have the following as a cell formula:

=MIN(P5:P65000)

I would like to add a condition to this Min() to make sure it only retrieves
the Min() where the value in column I is not null.

HOW?

Thanks in advance,
geebee

Min()
 

=MIN(IF(I5:I65000="","",P5:P65000)
Then press Ctrl+Shift+Enter as this is an array formula

Charles Chickering

geebee wrote:
hi,

I have the following as a cell formula:

=MIN(P5:P65000)

I would like to add a condition to this Min() to make sure it only retrieves
the Min() where the value in column I is not null.

HOW?

Thanks in advance,
geebee