Avatar Board Regular Joined Sep 20, 2005 Messages 193 Dec 8, 2005 #1 Greetings all, Basically i'm looking for a way to find a string in a column and return it's row number. Sounds mega simple to me, but i'll be damned if i can figure this one out.. I can't use code on this one though.
Greetings all, Basically i'm looking for a way to find a string in a column and return it's row number. Sounds mega simple to me, but i'll be damned if i can figure this one out.. I can't use code on this one though.
sykes Well-known Member Joined May 1, 2002 Messages 1,760 Office Version 365 Platform Windows Dec 8, 2005 #2 Try: As long as your column starts in A1, otherwise you'll have to put a bit of simple maths on the end: =MATCH("*yourstring*",A1:A100,0) ...... retain both the " and the *
Try: As long as your column starts in A1, otherwise you'll have to put a bit of simple maths on the end: =MATCH("*yourstring*",A1:A100,0) ...... retain both the " and the *