Finding a string in a column, and returning it's position..

[Avatar]

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]

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 *

 

[Avatar]

Perfect thanks mate