• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Remove Duplicate

A

Abhijeet

Active Member
Hi

In excel 2010 onwards Data Tab Remove Duplicate Option but in this all duplicate entries deleted from data i want all duplicate entries goes in next Duplicate Sheet how to do this please tell me
 

Hi !

The title of your thread is not correct ! (again !)

Different ways ! Depends on your VBA skills …

One is to copy all data in Duplicate worksheet twice in two separate ranges.
On second range (under first one with at least a blank line) apply
Remove Duplicate option. Now you can delete same remaining lines
from first range and then delete second range.
You can use an helper column with line number
to easy compare lines between ranges …

Another one is to use an advanced filter with a calculated criteria
like a COUNTIF worksheet function to keep all lines > 1
or using MATCH worksheet function to keep all lines with numeric result …
​
 
Hi

I use this formula to identify duplicate but tell me 1st value i do not want to show Duplicate please tell me how to do this
=IF(COUNTIF($A$1:$A$5,A1)>1,"Duplicate","No")
 
Hi
I found one solution =IF(COUNTIF($A$1:A1,A1)>1,"Duplicate","No")
but apart from this if any please tell me
 


So you can filter (advanced or single filter) with your formula helper column
based upon "Duplicate" result. Done for me …

​
 
Yes i know put filter get the result i am asking any other way to give this result is their then please tell me
 
Abhijeet said:
Yes i know put filter get the result i am asking any other way to give this result is their then please tell me
Click to expand...

This is the easiest way what we have till now!!

as you have helper col so filter & copy or use advance filter to move the duplicates to next sheet & run remove duplicate from command. :p:p

there are lot's of post regarding filter & advance filter to loop. o_Oo_O
 
Hi Deepak
I know this formula =IF(COUNTIF($A$1:A1,A1)>1,"Duplicate","No") & also i know put filter copy paste duplicate data in next sheet

I am asking if any other way in VBA to do this task
 
You must log in or register to reply here.
Back
Top