tiz6mo3bph6kjhdrppfz.jpg

Hey there!

Please open the image, and then read my explanation below.

Each row has a certain ID and 2 other values..the IDs are repeated on purpose.

1) For each ID, there has to be only one row where Column 2 and Column 3 have the same value (so in this case ID 1, Row 2 satisfies this). - On the other hand, for ID 6, we'd have to add a new row (which Ive highlighted in green, Row 10).

2) For each ID, there cant be duplicate rows. i.e. For ID 2, we should delete Row 5 as it's a duplicate of Row 4.

I need VBA code to carry out the above 2 operations on a set of data..(there are actually way more than just 3 columns, Ive just shown 3 for this purpose)

Hope I've explained myself well. If you have any questions do let me know.

Thank you!