+ 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, rarely 2007
    Posts
    12,673

    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
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    60,630

    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" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.


    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite 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