*VBA* Only unique rows, but with one catch

Hi, I need a great deal of help making a macro.

So I want to identify unique rows based on one of the columns, for example Name, or Employee ID, or Social and delete duplicate rows. But Also, I have a Column called Letter Code. If there is Specific Text in that column for that row (specifically "18C"), I need that to be the row that is kept when the macro is deleting duplicates.

I know this sounds complicated, so I have attached a workbook with dummy raw data and desired output.

Any input would be much appreciated.

Try the attached

I'm still having problems, it is taking a long time to process, as my data set is large, so it is freezing. Also this dummy data was for 4 columns but there are actually 16. I'm wondering if there is a more efficient way to do this.

I Forgot to mention thanks for the help!

See if this runs faster.

Please Login or Register  to view this content.

Hi Jindon, thanks for the fast response. The macro is now processing very quickly, but there is 1 problem, it is not deleting duplicate rows properly. I would try to edit the code, but I have no idea what is actually going on. Is there any way you can change it so that the duplicates it deletes is based on column B?

Thanks again for the help thus far.

Ok

Just change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

This is amazing, thank you.

One last question, where do I change what to text look for in the letter code column?

For example if I wanted it to look for "18C" or "18C - None" where would I type that?

If that is the only condition then

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Otherwise, need to see all the combinations in that column.