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!
Bookmarks