have index match return nothing

[dmheller]

I have this equation {=INDEX(F7:AS7,1,MATCH(MAX(IF(F6:AS6>0,F6:AS6)),F6:AS6,0))}
row 7 is a bunch of names what i want returned
row 6 is maybe some numbers and maybe 0 and could all be 0
if all of row 6 is 0, i want the equation to return nothing. Now if they all go to 0, it retuns the last value. Any thoughts.

 

[Marcelo Branco]

MAX does not return an error if no value> 0, but LARGE(....,1) does.

So try
=IFERROR(INDEX(F7:AS7,1,MATCH(LARGE(IF(F6:AS6>0,F6:AS6),1),F6:AS6,0)),"")
Ctrl+Shift+Enter

M.

 

[dmheller]

Thank you so much, that works great. I will look up large vs max.

 

[Marcelo Branco]

You're welcome. Thanks for the feedback.

M.