+ Reply to Thread
Results 1 to 3 of 3

Count Unique Values for Multiple Criteria

  1. #1
    Registered User
    Join Date
    03-03-2011
    Location
    Milton, New York
    MS-Off Ver
    Excel 2010
    Posts
    1

    Count Unique Values for Multiple Criteria

    I've done numerous searches for this permutation of Counting Unique Values for Multiple Criteria, but have not been able to locate a solution.

    The requirement is to count the number of unique addresses in each city. The addresses have to be unique to a single city ONLY. So for example:

    City Address Addressee

    Millville 2 Elm Robertson
    Millville 15 Maple Jones
    Millville 9 Ash Michaels
    Millville 15 Maple Daley
    Denton 22 Hickory Fort
    Denton 80 Oak Carver
    Denton 2 Elm Thomas

    The desired results would be:

    City Quantity of Unique Addresses

    Millville 2
    Denton 2

    NOTE FOR MILLVILLE: 9 Ash is the only address that is unique to Millville, 15 Maple is listed twice, but counted once as a single unique address. 2 Elm is not counted because it also exists in the city of Denton.

    NOTE FOR DENTON: 22 Hickory and 80 Oak are the only unique address. 2 Elm is not counted because it also exists in the city of Millville.

    Attached is an example spreadsheet with more detail and an example of the formula that I attempted to use with incorrect results. Thanks in advance for your assistance.
    Attached Files Attached Files

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,168

    Re: Count Unique Values for Multiple Criteria

    Hi Tim and welcome to the forum,

    Will you allow a helper column and a Pivot Table for your answer? See if the attached does the correct counting.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,914

    Re: Count Unique Values for Multiple Criteria

    Can you tell which are the Unique addresses you count manually for Millville, Denton and Portland
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

+ 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. Count unique values based on multiple criteria
    By Jonathan11235 in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 05-19-2015, 10:02 PM
  2. Count unique values across 2 columns with multiple criteria
    By Skywalker01 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-29-2012, 08:04 AM
  3. Replies: 8
    Last Post: 07-13-2012, 06:00 AM
  4. Count Unique Values, but with multiple criteria
    By the northern monkey in forum Excel General
    Replies: 3
    Last Post: 02-02-2012, 07:45 AM
  5. Count Unique Values with Multiple Criteria
    By JohnV in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-17-2006, 01:10 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