Thread: Formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Todd Huttenstine[_2_] Todd Huttenstine[_2_] is offline
external usenet poster
 
Posts: 237
Default 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