p.s.: got the using of the first row, but was trying to exclude other than
capital "X", by using EXACT. was able to use EXACT in combination with other
functions before, but not sure if have quite right now. get a NA error with
this as well.

=IF(ISNA(MATCH("X",$AU$1:$AU$1097,0)),"",MATCH(EXA CT($AU$1:$AU$1097,"X"),$AU$1:$AU$1097,0))


"Toppers" wrote:

The MATCH function returns the first occurrence of a value so if the data was
in A1:A200 and the first occurence of "X" was in row 55, MATCH returns 55. I
am assuming we are comparing a cell value and not part of a string.

=MATCH("X",A1:A200,0)

Is this what you require?

"nastech" wrote:

was wondering if it is possible to have a formula tell you the next line
number / the first occurance of a letter, "x", in one column? thanks