+ Reply to Thread
Results 1 to 3 of 3

CountIf but have duplicate values

  1. #1
    Registered User
    Join Date
    11-30-2020
    Location
    Canada
    MS-Off Ver
    2016
    Posts
    1

    CountIf but have duplicate values

    Hello, I am trying to count the number of times "positive" occurs however the positive could occur duplicate times for a unique value and I only want to count the positive the one time in that instance.



    For example and I would attach an actual example but it for whatever reason isnt working so I hope this will do.

    H235 Negative
    HA260 Negative
    H235 Positive
    H789 Positive
    HA852 Negative
    HA951 Negative
    HA951 Negative
    HA951 Positive
    H235 Positive

    I should only have 3 "positives" as H235 & HA951 has a duplicate positive

    Any assistance on this is greatly appreciated
    Last edited by WangA; 11-30-2020 at 04:22 PM.

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

    Re: CountIf but have duplicate values

    Cross posted https://www.mrexcel.com/board/thread...alues.1154638/

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

    Re: CountIf but have duplicate values

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

    Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

    (Note: this requirement is not optional. No help to be offered until the link is provided.)
    As you are new I have added the link for you.

+ 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. Countif only on duplicate values within date range.
    By bigtunelover in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-28-2020, 05:29 AM
  2. countif to return "x" for unique & "xx" for duplicate values in a column
    By Shruder in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-27-2018, 05:31 PM
  3. COUNTIF non duplicate values that begin with TWO choices
    By LinaVa in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 01-03-2015, 03:18 PM
  4. [SOLVED] COUNTIF non duplicate values that begin with
    By LinaVa in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-17-2014, 11:58 AM
  5. COUNTIF non duplicate values that begin with
    By LinaVa in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-16-2014, 09:23 AM
  6. Replies: 1
    Last Post: 03-03-2014, 11:06 AM
  7. VBA helps needed to Sum duplicate values and delete duplicate rows
    By krjoshi in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-03-2013, 11:40 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