Identify and Segregate Duplicates via VBA

Hi All,

I need some assistance to be able to Identify and Segregate Duplicates based on data in 3 columns. I have a huge chunk of data that needs to be processed each day.

The attached sheet has some data in Tab 1 with the logics along with the required output in Tab 2 & 3.

Request you to assist me on this using VBA.

Thank you in advance!

Spi

try the macro it will execute all requested actions

Thanks a ton!

Looks great and exactly in line with my request.

I'll run it against my data base and comeback to close the thread by tomorrow.

Much much appreciated!!!

Best regards,
Spi

Dearest RCM,

The solution provided is absolutely phenomenal!

Just a couple of small things if you could help me out on:

1. Row 4 of the DATA tab is the header row, that gets invisible whenever I run the solution. Is it possible to make a slight change so that it is visible?
2. Sheet1 can that have the Header Row as well similar to the Data Tab. Of course, Column A and B can read “Concatenation” & “Frequency” due to the logics applied

Rest all is working perfectly.

Thanks much!

Spi

OK

I made sure that row 4 was yellow shaded
sheet1 was only intended to be used as a worksheet but nevertheless I coded the headers to be inscribed

I color clear each row in data before evaluation so if the data changes it wont be erroneously highlighted.

Cheers,

Absolutely perfect! Thanks for this brilliant piece

The only thing that is happening additionally is that the Data sheet rows are getting highlighted completely, as against the previous one where it was only highlighting until the column the data was available. No real worries though, I’ll remove the colour manually.

Marking the thread as “Solved”

Best regards,
Spi