Plot first occuring number only

[Sekars]

Hello Friends

I need to plot the first occuring number only remaining should be #N/A in light yellow cells by formula.

thanks in advance

[shukla.ankur281190]

Try

E3=IF(AND(ISNUMBER(C3),ISNA(C2)),C3,NA()) and drag down!!!

[Sekars]

Hello Ankur

Thanks for your formula, This meets my exact requirement.

thanks again

[shukla.ankur281190]

Glad it helps you and thanks for feedback