+ Reply to Thread
Results 1 to 5 of 5

Identify duplicate groups of cell in column

  1. #1
    Registered User
    Join Date
    10-11-2013
    Location
    falkirk
    MS-Off Ver
    Excel 2007
    Posts
    69

    Identify duplicate groups of cell in column

    I have a large amount of list data entered on a sheet and need to know if any duplications have occurred. Is there any way to identify that groups of cells are unique to the sheet? This could be single or multiple occurrences of a string e.g. "town names". A formula would be preferable as opposed to vba. Possibly a conditional format?

    e.g.:
    A
    Town name
    Basildon
    Basildon
    Basildon
    Bedford
    Bedford
    Gourock
    Swansea
    Swansea
    Bedford <<< need warning of duplication here.

    I can find many instances on how to identify duplicate single entries but not when grouped like this.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,485

    Re: Identify duplicate groups of cell in column

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    and copy down.


    Conditional Formatting; select cells A2 down and use the CF condition: Formula:
    Formula: copy to clipboard
    Please Login or Register  to view this content.



    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    10-11-2013
    Location
    falkirk
    MS-Off Ver
    Excel 2007
    Posts
    69

    Re: Identify duplicate groups of cell in column

    Thanks TMS, that works beautifully!
    Marked as solved.

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,485

    Re: Identify duplicate groups of cell in column

    You're welcome. Thanks for the rep.

  5. #5
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,485

    Re: Identify duplicate groups of cell in column

    @sktneer: thanks for the rep and feedback.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 06-01-2013, 01:27 AM
  2. [SOLVED] How to identify those names shared by two groups and do a sum-up?
    By zjianguk in forum Excel General
    Replies: 5
    Last Post: 03-14-2013, 12:53 PM
  3. identify earliest & latest date groups in table
    By Brontosaurus in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 07-19-2011, 04:26 PM
  4. Duplicate Text within single cell. How to identify & split
    By TeRex82 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-21-2006, 03:35 AM
  5. [SOLVED] How can you identify duplicate entries in a singe column?
    By Melissa in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-04-2006, 05:25 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1