+ Reply to Thread
Results 1 to 5 of 5

counting the number of unique text items in a column

  1. #1
    Registered User
    Join Date
    04-19-2021
    Location
    UK
    MS-Off Ver
    0365
    Posts
    6

    counting the number of unique text items in a column

    Hello
    Can someone please help me with the following

    If I have a single excel column where each cell can contain one of a few text values as follows. I want another blank column to total up each item for example total text1 = 4, total text2 = 3, total text3 = 3

    text1
    text2
    text1
    text3
    text3
    text2
    text1
    text1
    text2
    text3

    can someone please assist me with this

    Thanks in advance
    Charlie

  2. #2
    Forum Expert sweep's Avatar
    Join Date
    04-03-2007
    Location
    Great Sankey, Warrington, UK
    MS-Off Ver
    2003 / 2007 / 2010 / 2016 / 365
    Posts
    3,440

    Re: counting the number of unique text items in a column

    Hi,

    =COUNTIF(A1:A10,"text1") will return the number of times "text1" appears in your list.
    Rule 1: Never merge cells
    Rule 2: See rule 1

    "Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".

  3. #3
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: counting the number of unique text items in a column

    Since you are using O365, you have Get and Transform available to you on the Data Tab.

    Please Login or Register  to view this content.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  4. #4
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,029

    Re: counting the number of unique text items in a column

    If you have the LET function
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    04-19-2021
    Location
    UK
    MS-Off Ver
    0365
    Posts
    6

    Re: counting the number of unique text items in a column

    Thanks very much, everyone those were quick replies

    I will take a look at the replies, much appreciated

    Charlie

+ 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. counting number of unique items in a column
    By johnnymac in forum Excel General
    Replies: 3
    Last Post: 11-26-2018, 01:35 PM
  2. [SOLVED] Count the number of Unique Items in a Column for each Unique Item in another Column
    By HangMan in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-27-2015, 01:18 PM
  3. Counting unique items on a list based on date in adjacent column
    By Mafoo17 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-30-2013, 04:24 PM
  4. [SOLVED] Counting unique values (text or number) in one column
    By djaurit in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-06-2012, 03:13 PM
  5. counting number of unique items in column
    By maacmaac in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-10-2008, 02:17 PM
  6. counting unique items(values or text)
    By guneet_ahuja in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 08-22-2006, 02:52 AM
  7. Counting the Number of Unique Items Sold by Each Salesperson
    By ExcelTip in forum Tips and Tutorials
    Replies: 0
    Last Post: 08-25-2005, 06:14 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