Search for string with repeats in the searching range

[Hallet]

Hi all,


I am doing a string search down a column, I need a macro that let's when detects multiples (repeats) of that string, it tells me the row number of all occurences.



For ex: Looking for string "dog"


1 cat
2 dog
3 fish
4 cat
5 cat
6 dog
7 dog
8 fish
9 bird
10 bird
11 fish


I need an if then statement if possible, If it finds multiples of the string being searched, then it will return the row number to me

[JBeaucaire]

Give this a try:

Please Login or Register  to view this content.

[xladept]

Hi Hallet,

Here's another way:

Please Login or Register  to view this content.

And the way to invoke it:

Please Login or Register  to view this content.

[Hallet]

Thank you very much JBeaucaire and xladept,
it works great!


Much appreicated



Hallet

[xladept]

You're welcome!