Results 1 to 5 of 5

How to count unique values in two ranges that meet conditions

Threaded View

  1. 11-18-2015, 06:26 AM #1
    akbermo
    akbermo is offline
    Registered User
    Join Date
    12-08-2011
    Location
    Brisbane, Australia
    MS-Off Ver
    Excel 2003
    Posts
    3

    How to count unique values in two ranges that meet conditions

    Cant work this out.

    4kiqIHh.png

    https://i.imgur.com/4kiqIHh.jpg

    I've got those formulas in two different sheets. How can I get a count of the unique values in both ranges in a single cell? i.e the count of those shown in yellow?

    EDIT: 1003 and 1007 should be highlighted yellow in the second range as well.Book1.xlsx
    Last edited by akbermo; 11-18-2015 at 06:49 AM. Reason: uploaded workbook
    Reply With QuoteRegister To Reply
« 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. [SOLVED] Count only unique values with two conditions
    By Melon6 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-01-2015, 05:24 AM
  2. How to calculate unique count of values in a column that does not meet a criteria.
    By Vishnu Balan in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-08-2014, 04:05 PM
  3. Count number of contiguous values in a range which meet conditions
    By LAUGHINGCROW in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 09-15-2014, 09:25 AM
  4. Count unique values within a range that meet a specific condition
    By CSS in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 06-24-2013, 02:00 PM
  5. Count Unique Values that Meet Criteria AT LEAST TWICE
    By yoft in forum Excel General
    Replies: 25
    Last Post: 05-31-2012, 08:03 PM
  6. Count unique distinct values that meet multiple criteria in closed workbook
    By efernandes67 in forum Excel General
    Replies: 5
    Last Post: 03-13-2012, 06:05 AM
  7. Count unique entries in one column that meet conditions
    By JayUSA in forum Excel General
    Replies: 6
    Last Post: 01-17-2010, 07:30 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