Re: $$Excel-Macros$$ find doubling

Hi sort your Data and Insert A Coloum and insert this Function : =Countif($A$1:A1,A1) On Mon, Oct 3, 2011 at 11:48 AM, Suman wrote: > Use this =countif(A:A,A2)>1 in conditional formating. Its compares all of > the values in column A to the contents of cell A2 the condition is TRUE if > there r m

Re: $$Excel-Macros$$ find doubling

Use this =countif(A:A,A2)>1 in conditional formating. Its compares all of the values in column A to the contents of cell A2 the condition is TRUE if there r more den one. After dat set the format if there r duplicate. Then use filter by color. On Sun, Oct 2, 2011 at 11:05 AM, anil kumar wrote: >

Re: $$Excel-Macros$$ find doubling

You can Also use Conditional Fomatting in Excel-2007 to Identify Dulicatte Recort. GoTo Conditional Formatting -> new Rule -> Format Only Unique Or Duplicate Values . Regards Rajan On Sun, Oct 2, 2011 at 5:45 PM, Sam Mathai Chacko wrote: > Here's one way of doing it. > > Sub CopyDuplicates() >

Re: $$Excel-Macros$$ find doubling

Here's one way of doing it. Sub CopyDuplicates() With Range("B2:B" & Cells(Rows.Count, 1).End(xlUp).Row) .Formula = "=COUNTIF($A$2:$A$" & Cells(Rows.Count, 1).End(xlUp).Row & ",A2)" .Value = .Value .Cells(0) = "COUNT" .Cells(0).Resize(.Rows.Count + 1).AutoFilte

Re: $$Excel-Macros$$ find doubling

Hi suman, I have a address software in which data enterd by other opprters and I think some data is double so i want to export data from there in excel short out double data than i will remove that data from software. so i wanted to printout that double address. Anil --

Re: $$Excel-Macros$$ find doubling

Hi, Anil I think u want to keep in ur file that data also which comes 2 or 3 time but after removing 2nd or 3rd data which is repeating in ur file if i'm ri8. Then u sud chose A to z in example data then simply write in 2nd column =A2=A3 then drag them n it will return True of False. False value wu

Re: $$Excel-Macros$$ find doubling

ay, September 30, 2011 3:43 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ find doubling Dear dguillett and noorani, I don't want to remove double I want show that and copy in other sheet. for

Re: $$Excel-Macros$$ find doubling

Hi Anil, Please find the attached sheet. here i am using countif function with if function . and later on autofilter to draw the value of duplicate value. and then then later on you can copy that A-Column data. On Wed, Sep 28, 2011 at 12:46 PM, anil kumar wrote: > Hi everybody, > > I have a file

Re: $$Excel-Macros$$ find doubling

Hello suman, thanks for reply, it works and fulfill my needs. but not that way I want. If you have better Idia plz send me. Thanks & Regards Anil >> > -- -- Some important links for excel users: 1. Follow us on

Re: $$Excel-Macros$$ find doubling

Dear dguillett and noorani, I don't want to remove double I want show that and copy in other sheet. for removing I use Alt +AM > Thanks & Regards > Anil -- -- Some important links for excel users: 1. Follow us

Re: $$Excel-Macros$$ find doubling

Dear Anil, Please use simple Macro *Sub remove_duplicate()* *Dim s As Range Sheet1.Range("A2:A" & Application.WorksheetFunction.CountA(Range("A:A"))).Select Selection.RemoveDuplicates 1 End Sub * -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*

Re: $$Excel-Macros$$ find doubling

p End With Columns(1).Delete Columns(1).AutoFit End Sub From: Suman Sent: Thursday, September 29, 2011 1:27 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ find doubling Hi, Anil Please find the attached sheet if it helps you. On Thu, Sep 29, 2011 at 10:54 AM, anil kumar

Re: $$Excel-Macros$$ find doubling

Anil Sort the data after use formula. Regards, Brajesh On Thu, Sep 29, 2011 at 10:54 AM, anil kumar wrote: > Hello sir, > > > frist of all thanks for reply. I used your formula but it is not work > according to my data. I have attched that file. plz see that. > > > > Thanks & Regards > > > A

Re: $$Excel-Macros$$ find doubling

Hello sir, frist of all thanks for reply. I used your formula but it is not work according to my data. I have attched that file. plz see that. Thanks & Regards Anil -- -- Some important links for excel users:

Re: $$Excel-Macros$$ find doubling

Dear Anil, See below formula if it help to You. =IF(A2=A3,"Duplicate","Unique") Regards, Brajesh On Wed, Sep 28, 2011 at 12:46 PM, anil kumar wrote: > Hi everybody, > > I have a file in which some data is double i want to find that data. I used > short key Alt + AM but it is remove double d

$$Excel-Macros$$ find doubling

Hi everybody, I have a file in which some data is double i want to find that data. I used short key Alt + AM but it is remove double data insted of show data i want to copy that data. Thanks & Regards Anil --