CODEWITHSUNDEEP
excel-formula
Jose Perez
Jose Perez

Reputation: 1

Need formula to ignore zero

Need help to have this formula ignore zero values as being the min value.

=IF(L4="",INDEX($D$3:$K$3,MATCH(MIN(D4:K4),D4:K4,0)),HLOOKUP(L4,$D$2:$K$3,2,FALSE))

Upvotes: 0

Views: 43

Answers (1)

Gary's Student
Gary's Student

Reputation: 96781

As Scott points out replace:

MIN(D4:K4)

with:

MINIFS(D4:K4,D4:K4,"<>0")

(just insert this as a replacement)
MINIFS() by itself, does not require array-entry.

Upvotes: 1

Related Questions