+ Reply to Thread
Results 1 to 8 of 8

Finding duplicate data quickly in a row?

  1. 12-05-2009, 08:55 PM #1
    lesliepear
    lesliepear is offline
    Registered User
    Join Date
    12-05-2009
    Location
    Little Ferry, NJ
    MS-Off Ver
    Excel 2000
    Posts
    3

    Finding duplicate data quickly in a row?

    I have a spreadsheet with 1500 e-mails in a column - what is a quick way I can find duplicate e-mails in my column to delete the duplicate data?

    Thanks
    Reply With QuoteRegister To Reply
  2. 12-05-2009, 08:58 PM #2
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Finding duplicate data quickly in a row?

    In an adjacent column, =if(countif(A$1:A1, A1)>1 "Dup", "")
    Entia non sunt multiplicanda sine necessitate
    Reply With QuoteRegister To Reply
  3. 12-05-2009, 09:00 PM #3
    darkyam
    darkyam is offline
    Forum Expert darkyam's Avatar
    Join Date
    03-05-2008
    Location
    Houston, TX
    MS-Off Ver
    2013
    Posts
    2,191

    Re: Finding duplicate data quickly in a row?

    Or you could use advanced filter and have it either shorten the list to unique values in place or copy the unique values to another range.
    Reply With QuoteRegister To Reply
  4. 12-05-2009, 09:01 PM #4
    teylyn
    teylyn is offline
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Finding duplicate data quickly in a row?

    darkyam, XL 2000 doesn't do unique filtering. That's new with 2007
    Microsoft MVP
    http://www.teylyn.com
    Twitter: http://twitter.com/IngeborgNZ
    Reply With QuoteRegister To Reply
  5. 12-05-2009, 09:03 PM #5
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Finding duplicate data quickly in a row?

    I think Advanced Filter always supported unique filtering, T.
    Reply With QuoteRegister To Reply
  6. 12-05-2009, 09:04 PM #6
    solnajeff
    solnajeff is offline
    Forum Contributor
    Join Date
    04-21-2007
    Location
    Lima, Peru
    MS-Off Ver
    2000, 2007, 2010
    Posts
    674

    Re: Finding duplicate data quickly in a row?

    HI

    Providing the cell contents are identical then the following code should be okay.

    Please Login or Register  to view this content.
    Regards

    Jeff
    Reply With QuoteRegister To Reply
  7. 12-05-2009, 09:07 PM #7
    teylyn
    teylyn is offline
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Finding duplicate data quickly in a row?

    time to polish my contacts ... was reading autofilter instead of advanced filter ....
    Reply With QuoteRegister To Reply
  8. 12-05-2009, 09:50 PM #8
    pike
    pike is offline
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,330

    Re: Finding duplicate data quickly in a row?

    or maybe
    Please Login or Register  to view this content.
    If the solution helped please donate to RSPCA

    Site worth visiting: Rabbitohs
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1