Formula

[Todd Huttenstine]

Below is a range of data. The range may contain 1 or more
#N/A errors. I need a formula that will return the
location of the 1st instance it finds the 1st or only #N/A
error. For Instance, the formula would return the number
2, because 2 is the position of the 1st #N/A error.

Column J
1
#N/A
3
4
5
#N/A





Thanx
Todd Huttenstine

 

[zantor]

Hi Todd,

Below is a file called Todd.zip. See if it is what you want.


regards
Zantor

File Attached: http://www.excelforum.com/attachment.php?postid=333812 (todd.zip)

 

[J.E. McGimpsey]

One way (array-entered: CTRL-SHIFT-ENTER or CMD-RETURN)

=MATCH("$%^",IF(ISNA(J1:J100),"$%^",A1:A100),FALSE)