Results 1 to 6 of 6

Count unique text strings in a column

Threaded View

  1. #1
    Registered User
    Join Date
    12-05-2023
    Location
    Cardiff
    MS-Off Ver
    Version 16.79.2 MAC
    Posts
    4

    Question Count unique text strings in a column

    I'd appreciate some help.

    I have a column of tags. Each cell can have multiple tags separated by commas. Each cell will have a unique set of tags within that cell, but tags can be repeated in other rows.

    e.g.
    Dog, Duck, Barn, Door
    Dog, Cat, Cow
    Door, Sheep, Goat
    Barn, Farmer, Dog

    How do I list out the unique tags only and then count how many of those unique tags are in the column?

    Ideally what I'd like is the unique tags listed in one column with the count in the next column. e.g.

    Dog 3
    Duck 1
    Barn 2
    Door 2
    Cat 1
    Cow 1
    Sheep 1
    Goat 1
    Farmer 1

    thanks
    Last edited by Darren Waters; 12-05-2023 at 10:53 AM. Reason: Solved

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Count Unique (Long) Strings
    By eNinjaInTraining in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-15-2021, 10:23 PM
  2. [SOLVED] Using a Referencing a Column to Count 2 different text strings in another Column
    By marshallmr in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-05-2019, 02:02 PM
  3. Replies: 20
    Last Post: 08-24-2017, 02:40 AM
  4. [SOLVED] Need count of unique text values in column
    By kitpierce in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-21-2017, 01:01 PM
  5. [SOLVED] count text strings in column but ignore duplicates & blanks
    By y_not in forum Excel General
    Replies: 4
    Last Post: 06-28-2015, 11:57 AM
  6. [SOLVED] How do I count the # of unique occurences of a text in a column?
    By Rob Kaiser in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-14-2005, 02:05 AM
  7. Count Unique Strings
    By [email protected] in forum Excel General
    Replies: 4
    Last Post: 04-27-2005, 03:06 PM

Tags for this Thread

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