Hi Amlan
This will take a while to run on a million rows. I wanted to check this
in case data in cell E is same and repeats in all 5 entries ,i want all except 1 to be retained
Is that correct...you want 4 retained and only 1 deleted? Don't know if I can manage that.