I have records like below. Aim is that the
Last duplicate record shall stay test shall get deleted.
In below example Row 1,Row 2 shall get deleted because A1 is duplicate 3 times. How can I achieve this for large number of Randomly arranged records?
Column A. Column B
A1. B1
A1. B2
A2. A21
A1. B3