+ Reply to Thread
Results 1 to 2 of 2

Formula - Find duplicate concatenated characters in single cell

  1. #1
    Registered User
    Join Date
    10-15-2014
    Location
    Orlando, FL
    MS-Off Ver
    2008
    Posts
    2

    Formula - Find duplicate concatenated characters in single cell

    Hi Folks,

    I'm scratching my head trying to figure out how to count duplicates among concatenated characters within a single cell.

    An example would be:

    Please Login or Register  to view this content.
    I got pretty close with the solution here: http://www.excelforum.com/excel-gene...in-a-cell.html

    Please Login or Register  to view this content.
    This however indexes all of A and counts the duplicates amongst the entire array instead of returning individual results for each neighboring row.

    I need a formula that will translate well to Google Spreadsheets as well.

    Any ideas??

  2. #2
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: Formula - Find duplicate concatenated characters in single cell

    With your sample data in A1:A4
    this regular formula, copied down, returns the count of non-unique values
    Please Login or Register  to view this content.
    Is that something you can work with?
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

+ 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. Find duplicate characters in a cell?
    By Paik4Life in forum Excel General
    Replies: 10
    Last Post: 06-02-2022, 12:45 PM
  2. [SOLVED] Find count of Unique or Duplicate Values based on Concatenated values in 2 columns
    By bdicarlo1 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 12-03-2014, 12:42 AM
  3. Replies: 5
    Last Post: 08-06-2014, 12:22 PM
  4. Find an exact duplicate match on concatenated cells
    By madball87 in forum Excel General
    Replies: 2
    Last Post: 10-04-2011, 06:07 AM
  5. How to add a Single " i.e. (DOUBLE QUOTE) in a Concatenated Formula?
    By e4excel in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-05-2011, 08:37 AM

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