find doubling

find doubling

Post by anil kuma » Thu, 29 Sep 2011 16:16:13



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

 
 
 

find doubling

Post by Brajesh Kumar Porwa » Thu, 29 Sep 2011 16:44:18


Dear Anil,

See below formula if it help to You.

 =IF(A2=A3,"Duplicate","Unique")

Regards,
Brajesh


> 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

> --

> ----------------------------------------------------------------------------------
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip

> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com


> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel


 
 
 

find doubling

Post by hemal sha » Thu, 29 Sep 2011 21:09:52


If you have excel 2007 then follow the following procedure

Select the your data range and go to Home --> Conditional Formatting
-->Highlight Rules--> Duplicate Values..

It will highlight your duplicate data and by filtering it you can copy it.

Regards
Hemal
9260544391

 
 
 

find doubling

Post by anil kuma » Fri, 30 Sep 2011 14:24:03


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

  for example.xlsx
12K Download
 
 
 

find doubling

Post by Brajesh Kumar Porwa » Fri, 30 Sep 2011 15:22:47


Anil

Sort the data after use formula.

Regards,
Brajesh


> 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:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip

> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com


> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel

  for example_Anil.xlsx
13K Download
 
 
 

find doubling

Post by Suma » Fri, 30 Sep 2011 15:27:47


Hi, Anil
Please find the attached sheet if it helps you.


> 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:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip

> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com


> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel

--

       ??`?.(*?.?(`?.?*?.?)?.?*).?`??
?*?.??.*.....~*--Suman --*~......*.??.?*`?
       ??`?.(?.?(?.? * ?.?)`?.?).?`??

Mob: +91 9810333884

  A_html_m691da4f3.gif
43K Download

  Find RepeatingSOLVED.xls
32K Download
 
 
 

find doubling

Post by Brajesh Kumar Porwa » Fri, 30 Sep 2011 16:02:00


Hi hamal,

Use can use filter if it help to you.

Ctrl+Shift+L -> drop filter -> *filter by color* -> *filter by cell
color *-> Press
enter.

Regards,
Brajesh


> If you have excel 2007 then follow the following procedure

> Select the your data range and go to Home --> Conditional Formatting
> -->Highlight Rules--> Duplicate Values..

> It will highlight your duplicate data and by filtering it you can copy it.

> Regards
> Hemal
> 9260544391

> --

> ----------------------------------------------------------------------------------
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip

> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com


> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel

 
 
 

find doubling

Post by dguillett » Fri, 30 Sep 2011 22:11:19


This will remove the duplicates. If you have xl2007 you could use the remove duplicates

Sub advancedfilterunique()
lr = Cells(Rows.Count, 1).End(xlUp).Row
With Range("A1:A49")
.AdvancedFilter Action:=xlFilterCopy, _
CopyToRange:=Range("b1"), Unique:=True
.Delete Shift:=xlUp
End With
Columns(1).Delete
Columns(1).AutoFit
End Sub

From: Suman
Sent: Thursday, September 29, 2011 1:27 AM

Subject: Re: $$Excel-Macros$$ find doubling

Hi, Anil
Please find the attached sheet if it helps you.

  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:
  1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip

  3. Excel tutorials at http://www.excel-macros.blogspot.com
  4. Learn VBA Macros at http://www.quickvba.blogspot.com
  5. Excel Tips and Tricks at http://exceldailytip.blogspot.com


  <><><><><><><><><><><><><><><><><><><><><><>
  Like our page on facebook , Just follow below link
  http://www.facebook.com/discussexcel

--

       ??`?.(*?.?(`?.?*?.?)?.?*).?`??
?*?.??.*.....~*--Suman --*~......*.??.?*`?
       ??`?.(?.?(?.? * ?.?)`?.?).?`??

Mob: +91 9810333884

--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip

3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com


<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

  A_html_m691da4f3.gif
43K Download
 
 
 

find doubling

Post by NOORAIN ANSAR » Sat, 01 Oct 2011 14:43:09


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/*<http://excelmacroworld.blogspot.com/>
*http://noorain-ansari.blogspot.com/* <http://noorain-ansari.blogspot.com/>


> 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

> --

> ----------------------------------------------------------------------------------
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip

> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com


> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel

 
 
 

find doubling

Post by anil kuma » Sat, 01 Oct 2011 17:43:59


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

Quote:>  Thanks & Regards

  Anil