Match and find in adjacent cells with criteria.

Hello all,

In col BD I am wanting to find text or numbers that are exactly the same but must be in adjacent cells. I have 4 x samples in results col I.
These samples are as follows.

kikd
kn
no finish
ulky

In these cells the there will be all forms of text or numbers or any combination of all. No numbers in this sample.

Most horses have 3 runs in this sheet, run number 1 2 3 col AU, some will have only have 2 or 1 run. If only 1 run, then a match can never be found.
Col AF is their race number on the day.
Col N is the actual race number.
Cols B and D, 2 different dates and meetings.

Finding the exact matches, I need must be for the same horse only, meaning they will have exactly the following 5 mentioned criteria.

1- same date
2- same meeting name
3- same race number
4- same T# there number on the day
5- same match in adjacent cells being runs 1 and 2, 2 and 3, not 1 and 3.

Placing an X beside these would be a good start, but a macro to find exact match after I enter what I needed would be better.

Thanks.

Please Login or Register  to view this content.

Thanks John can't complain about that result, more than I expected.
If I was to only want the four sample words
kikd
kn
no finish
ulky
And I am able to enter these four words (type of words) manually into a macro, would that be possible. This way I can change as I like.
Thanks.

Also getting run time error 9 on a 25,000 row sheet, this line of code in yellow.

If InStr(1, a(i + 1, 56), v(j)) > 0 Then

Thanks.

As I am getting the above error as in my post #3, I started cutting my sheets to smaller sizes, some worked on 3,200 rows and some on much much smaller sheets.
Then I came to just one race where the macro doesn't want to go past, the only thing I can see is col BD first three cells are empty, but I tried filling them and still getting error 9.

Got halfway thru doing manually. Grrrrrwwwww. Still happy to have a result tho.

Noticing in col BD, when there are blank cells at the bottom of a race and blank cells at beginning of very next race error occurs. Will upload a sample of this v3.

Just bumping this as unanswered questions in post 4.
Thanks.

Please Login or Register  to view this content.

Issue with "kn" as you have "wknd" so a simple match on "kn" will give errors: used "kn," as a work-around.

There may be a better solution using the "Regex" function of which I have no experience.

Update to handle the "kn" situation:

Please Login or Register  to view this content.

Thanks John, I'm working with what you have to finalize my problems.

Can you take a look at this new sheet with your latest macro, still getting errors, different one this time.
I'm still trying to work out problem with your post two answer.
Thanks.

See attached

Few "oddities" in the data .. "no fin" vs "no finish" ?

Yes, there are many oddities in the data, bookies way of trying to trick people.
Your post #9 has fixed the problems I mentioned in posts 4 and 8. This macro is now able to work on a 24,000-row sheet without stopping.

Many thanks for your help and resulting answer.

You're welcome and thank you for the rep.