Results 1 to 7 of 7

Marking Distinct Values in Table based on multiple conditions

Threaded View

  1. #1
    Registered User
    Join Date
    07-02-2013
    Location
    Pakistan
    MS-Off Ver
    Excel 365
    Posts
    54

    Question Marking Distinct Values in Table based on multiple conditions

    Dear All,

    I am looking for a formula in a long datasets (Excel table) to identify Distinct Values based on multiple conditions.
    For Example:
    When Type = ONE, Year = 2019 so it should count that District and return 1 and skip the rest values in that year

    In past sheets, I have been using COUNTIFS but it is not accurately working here modified for this reason as below
    Formula: copy to clipboard
     =IF(COUNTIFS($A$3:$A3,"ONE",$B$3:$B3,2019,$C$3:$C3,C3)=1,1,"") 
    and
    Formula: copy to clipboard
     =IF(COUNTIFS($A$3:$A3,"ONE",$B$3:$B3,2020,$C$3:$C3,C3)=1,1,"")



    If you see in below picture so for 2020 it is working but in 2019 column its showing for 2020 as well (marked as red)

    Excel.jpg

    Please draft me an alternate or correction in above to get the desired results
    Attached Files Attached Files
    Last edited by naveeddil; 11-28-2020 at 03:41 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] COUNTIF for distinct values only for two conditions
    By JulianS96 in forum Excel Formulas & Functions
    Replies: 29
    Last Post: 02-25-2020, 07:18 AM
  2. [SOLVED] Finding and marking duplicate value based on two conditions
    By gesaugen in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-21-2016, 04:53 PM
  3. Sum column and count distinct values in another based on multiple criteria
    By mike.greene in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 01-12-2015, 11:50 AM
  4. Count distinct records that meet multiple conditions
    By rubthebuddha in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-18-2013, 09:54 AM
  5. Replies: 1
    Last Post: 10-01-2013, 02:41 AM
  6. Insert multiple values from seperate table based on multiple conditions
    By drakesong in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-28-2011, 06:04 PM
  7. look up table values with multiple conditions
    By TechMGR in forum Excel General
    Replies: 3
    Last Post: 01-09-2006, 08:55 PM

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