+ Reply to Thread
Results 1 to 4 of 4

Count Unique Text Values with 2 criterias/condition

  1. #1
    Registered User
    Join Date
    01-21-2020
    Location
    Singapore
    MS-Off Ver
    microsoft 2010
    Posts
    4

    Question Count Unique Text Values with 2 criterias/condition

    Hello everyone! I need some help on my excel spreadsheet. I tried to look for answers to resolve this for the past weeks but I got none that fits my current situation.

    In Cell T12, I need to get a total unique text values from "POP-WS Registration column" cells B48-B300 based on these criterias: 1.) it should be tagged as "Closed" in topic status cells G48-G300; 2.) It should be categorize as "Workshop Process Improvement/ Wastes Reduction" in CI topic nature cell I48-I300.

    Hope you could help me.
    Thanks!
    Attached Files Attached Files

  2. #2
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Count Unique Text Values with 2 criterias/condition

    Hello Kim_18. Welcome to the forum.

    Try this formula.
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    It returns 1 which is correct.
    Dave

  3. #3
    Registered User
    Join Date
    01-21-2020
    Location
    Singapore
    MS-Off Ver
    microsoft 2010
    Posts
    4

    Re: Count Unique Text Values with 2 criterias/condition

    Thank You Dave, this formula works for me.

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,365

    Re: Count Unique Text Values with 2 criterias/condition

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

+ 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. Count unique values in a table that meet one or two criterias
    By Greenyexcel in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-27-2019, 11:13 AM
  2. two condition before count unique text value.
    By Ensaac in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-28-2019, 09:00 PM
  3. Count Unique Values based on multiple criterias
    By Dahlia in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 04-10-2016, 09:10 AM
  4. Count Unique Values based on different Criterias
    By Morwick in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-03-2015, 04:49 PM
  5. [SOLVED] Count unique values based multiple criterias
    By Petter120 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-03-2014, 03:07 AM
  6. [SOLVED] How to count unique values using multiple criterias
    By Charmymay in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-07-2013, 11:27 AM
  7. Replies: 2
    Last Post: 01-17-2012, 07:48 AM

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