Consulting

Results 1 to 9 of 9

Thread: Count unique values based on multiple criteria

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 02-21-2012, 01:24 PM #1
    RKramkowski
    RKramkowski is offline
    VBAX Regular
    Joined
    May 2009
    Posts
    22
    Location

    Count unique values based on multiple criteria

    Hi,

    I've searched numerous forum and have not yet found an answer to my problem. Using a formula, I'd like to count unique occurrences in column A where Column B = a particular string AND Column C = a different string (and eventually Column D = yet another value).

    I've uploaded a spreadsheet that I expanded on from another forum where the solution was the closest I could find. Cells F15, G15, and H15 are my attempt at making this work. After spending several days on this, I feel I'm no closer to a solution than when I started.

    I found how to count occurrences based on the value of colum b and c but not UNIQUE values.

    Any ideas?
    Thanks,
    Bob
    Attached Files Attached Files
    Last edited by Paul_Hossler; 11-08-2019 at 10:15 AM. Reason: Used [Thread Tools] 'SOLVED' instead of Title edit
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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