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...