Hi
I have a worksheet contains around 4000 rows and quite a few duplicates some duplicated as many as 20 times. I want to find a way to sort them so that most duplicated rows are on the top and least duplicated are at the bottom.
Alternatively delete the duplicates rows but have a cell that shows howmany times that row was duplicated before the deletion.
Any help will be greatly appreciated.
Thanks