Need help with a nested IF with an ISNA (I think)

Originally Posted by tigeravatar

nighthalcyon,

In cell H2 and copied down:

=IF(COUNTIF(A2:G2,"<>#N/A")=0,"",INDEX(A2:G2,MATCH(FALSE,INDEX(ISNA(A2:G2),),0)))

Or if you don't mind seeing the #N/A error message if there is no number to return, you can leave off the first part:

=INDEX(A2:G2,MATCH(FALSE,INDEX(ISNA(A2:G2),),0))

Worked perfectly. Thanks very much for your help !!!

Edit: Looks like I've already repped you for some of your help earlier. But I'll get you again when I can.