This formula works fine but it enters results before all data has been entered.

=INDEX(B10:B49,IF(COUNT(AP10:AP49)=COUNTIF(AP10:AP 49,"<0"),MATCH(MAX(AP10:AP49),AP10:AP49,0),MATCH(M IN(IF(AP10:AP49=0,AP10:AP49)),AP10:AP49,0)))

My question is can this be prevented until the all data has been entered?

Thanks ahead!