search of first #N/A position
 

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.


--
owl527
------------------------------------------------------------------------
owl527's Profile: http://www.excelforum.com/member.php...o&userid=20916
View this thread: http://www.excelforum.com/showthread...hreadid=518084

search of first #N/A position
 

Try

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

where your names are in A1:A1000


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=518084