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
Hello Forest,
Take a look at this link on sorting it may help? Once you have sorted you can then do a count of duplicates on the row you wish to retain, copy and paste the values of the sum, then delete to duplicate rows.
http://www.contextures.com/xlSort01.html
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
See if my example in this thread helps you out at all. Report back with questions.
http://www.excelforum.com/showthread.php?t=622011
Bigbas Thanks
Great help but one little problem im having, I can not see the count.
=IF(COUNTIF($A$2:A2,A2)>1,"Duplicate","First Occurrence") works fine but how do i do the count?
Im using excel 2007 if it makes any difference.
Thanks for your time
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks