Formula
 

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

Formula
 

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)

------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

Formula
 

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

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

In article ,
"Todd Huttenstine" wrote:

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