CODEWITHSUNDEEP
excelformulamin
user3235881
user3235881

Reputation: 487

Get the minimum value if not null in Excel

I am trying to get the minimum Value from G2 to G101, only if the value is not null. I found different methods but none of them is working with me. I tried :

=MIN(IF(G2:G101>0,G2:G101))
=SMALL(G2:G101,COUNTIF($G$1:$G$101,0)+1)

I alwayse get the message : The formula you typed contain an error

Upvotes: 0

Views: 1024

Answers (1)

Gary's Student
Gary's Student

Reputation: 96753

You need the array formula:

=MIN(IF(G2:G101>0,G2:G101))

Array formulas must be entered with Ctrl + Shift + Enter rather than just the Enter key.

enter image description here

Upvotes: 3

Related Questions