Removing specific duplicates

[The Grim Discovery]

Hello people

In my worksheet I'm looking to delete duplicates found in Column A.
I'm finding that with the delete duplicate option it removes all but the first instance by default.
Is there a way of reversing this so only the last instance is kept?

Thanks in advance.

 

[Special-K99]

If they are duplicates why does it matter?
The only other factor would be the position of the remaining instance.

 

[Fluff]

This may sound a bit daft, but how about sorting the data in reverse before removing duplicates.

 

[kvsrinivasamurthy]

Let data is in A2:A20
In Column B (or a blank column) In B2:B20 Put Numbers from 2 to 20
Sort the whole data on Column B in descending order.
Now remove duplicates
Once again Sort the whole data on Column B in ascending order.
Delete data in Column B.

 

[The Grim Discovery]

Thanks people, very helpful as ever.