Find rows with same sequence of number in coloum entry and delete one of them

[Mitama]

Hallo

I have been looking for a solution for this specific problem with VBA but havent found any. I hope you can help me out.

I need to find those row couples that have in one specific coloum (A) the same searched for digits in the cell entry, like Apple9003 and garden4003 would be a pair because of the last three digits. I do not know before what digits will I have to search for, I just have to check the last 3 digits if they are the same.

The next step would be to not delete the one that has an entry in coloum M but the other one. I guess here I can just say if empty delete. The first task and the if loop is a problem for me.

Do you have any suggestions for me please?

INPUT TABLE

A ..................... B
Apple9003.........89
garden4003
house222
bird1222..........23
pizza777


OUTPUT TABLE
A........................B
Apple9003..........89
bird1222...........23
pizza777


Thank you very much!!

Mitama

[WideBoyDixon]

This might work for you:

Please Login or Register  to view this content.

WBD