search of first #N/A position

[owl527]

Hi,

I have a column of downloaded data which contains names and up to a certain row it will start displaying "#N/A", how do I find the row number of the first #N/A? Please help!! thank you very much.

[daddylonglegs]

Try

=MATCH(1,INDEX(ISNA(A1:A1000)+0,0),0)

where your names are in A1:A1000