+ Reply to Thread
Results 1 to 6 of 6

Count Distinct in Excel

  1. 05-29-2023, 01:23 PM #1
    AMJADMemon
    AMJADMemon is offline
    Forum Contributor
    Join Date
    11-28-2022
    Location
    CANADA
    MS-Off Ver
    Microsoft 365 Apps for enterprise
    Posts
    149

    Count Distinct in Excel

    Hello Folks,
    I am trying to apply formula for distinct value but it is working.
    I am trying to count ID and if repeat I want to put zero instead.

    here is the attachment and expected answer.

    Thanks
    Attached Files Attached Files
    Last edited by AMJADMemon; 05-29-2023 at 02:32 PM.
    Reply With QuoteRegister To Reply
  2. 05-29-2023, 01:44 PM #2
    Fluff13
    Fluff13 is offline
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,108

    Re: Count Distinct in Excel

    How about
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  3. 05-29-2023, 01:52 PM #3
    CARACALLA
    CARACALLA is offline
    Forum Expert
    Join Date
    09-25-2015
    Location
    Milan Italy
    MS-Off Ver
    office 365
    Posts
    1,788

    Re: Count Distinct in Excel

    B2=IF($A2<>"",IF(COUNTIF($A$2:A2,$A2)=1,COUNTIF($A$2:$A$100,$A2),0),"")

    Copy down
    Reply With QuoteRegister To Reply
  4. 05-29-2023, 02:30 PM #4
    AMJADMemon
    AMJADMemon is offline
    Forum Contributor
    Join Date
    11-28-2022
    Location
    CANADA
    MS-Off Ver
    Microsoft 365 Apps for enterprise
    Posts
    149

    Re: Count Distinct in Excel

    Thanks problem solved.
    Reply With QuoteRegister To Reply
  5. 05-29-2023, 02:32 PM #5
    AMJADMemon
    AMJADMemon is offline
    Forum Contributor
    Join Date
    11-28-2022
    Location
    CANADA
    MS-Off Ver
    Microsoft 365 Apps for enterprise
    Posts
    149

    Re: Count Distinct in Excel

    Thanks the problem is resolved
    Last edited by AMJADMemon; 05-29-2023 at 02:32 PM. Reason: Thanks
    Reply With QuoteRegister To Reply
  6. 05-29-2023, 02:44 PM #6
    Fluff13
    Fluff13 is offline
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,108

    Re: Count Distinct in Excel

    Glad to help & thanks for the feedback
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Excel: Countifs with distinct count
    By Nicolantonio in forum Excel General
    Replies: 1
    Last Post: 04-16-2021, 05:33 AM
  2. How to distinct count in Excel
    By Terressa in forum Excel General
    Replies: 13
    Last Post: 08-16-2015, 05:00 AM
  3. [SOLVED] How to count distinct values in Excel
    By Arpita_Excel in forum Excel General
    Replies: 7
    Last Post: 07-22-2015, 02:05 AM
  4. count distinct values in excel
    By annux08 in forum Excel General
    Replies: 3
    Last Post: 07-13-2015, 09:21 AM
  5. How to Count Distinct Values in Excel
    By kisanvikas2015 in forum Excel General
    Replies: 2
    Last Post: 05-19-2015, 10:12 AM
  6. Count distinct in excel
    By akshaykadidal in forum Tips and Tutorials
    Replies: 3
    Last Post: 01-07-2014, 08:20 AM
  7. [SOLVED] how can I count distinct names in an excel list?
    By RPC@Frito in forum Excel General
    Replies: 5
    Last Post: 02-03-2005, 06:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1