Find duplicates for each parent using VBA in Excel

[Saritha123]

Have to columns Column 1 and 2
For each value in Column 1 , will have multiple values in column 2.
Need to find our duplicates in Column 2 for each value in column 1.

Child values can be repeated for different parent values. But under each parent there should not be duplicate child values.
Need a VBA code to handle this.

Attached the sample excel, with expected output column.

[jindon]

Try

Please Login or Register  to view this content.

[Saritha123]

Thanks a lot.. for the quick solution.

For the given example it is working.
Could you please explain the solution in detail, so that I can apply the same solution on my actual data.
But, the actual data resides dynamically... in unlimited rows more than 10,000 rows.
When I tried to apply the same it is actually making the excel slow.

Could you please provide some performance efficient solution.

[jindon]

Please Login or Register  to view this content.

[Saritha123]

Thanks a lot for the quick reply and solution.
Solution is working fine for the given example.
Now, I have added another sheet to the excel named "Actual", where it resembles the real data.

In real data data will start from row 5, so we need start checking from row 5.
Parent value exists in column D and child value exists in column E.
We need to check if each parent have any duplicate child.
And the no of rows are dynamic in number.
Column position will be constant.
We need to write Duplicate or not under the column "Error Messages".

Sorry for bothering you as I am new to VBA, your help is really appreciated.

[jindon]

You must remember the given code is tailored to the data set you uploaded, so it MUST have same data layouts and data type when you upload a sample workbook.

Please Login or Register  to view this content.

[Saritha123]

Thanks a lot... for the solution.
It really did work well.

[jindon]

If that takes care of your original question, select Thread Tools from the menu link above and mark this thread as SOLVED.