Results 1 to 19 of 19

Count based on group membership

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-24-2009
    Location
    Germany, MG
    MS-Off Ver
    Excel 2010
    Posts
    131

    Count based on group membership

    Hi everyone, I would like to get the number of countries that a given "Name" has Partners in. (See example sheet for an illustration)
    I have the ID of a group in column A. Column B represents Names. Column C gives Info about the country of "Name".
    In column D I would like to get the information how many unique countries a "Name"'s group members are from. This means, not only within a single group, but in total over all groups. This means, that every same Name has the same number of countries in column D.

    Does anyone know how to do this?

    Formula in words:
    "sum of all unique countries in column C, if ID in column A matches any ID of Name in column B"

    Thanks a lot in advance!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 02-10-2014, 10:26 PM
  2. Need help: Basic Math / Excel Problem based on Membership Subscriptions
    By lesoies in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-14-2013, 11:09 PM
  3. Need a macro to count certain days Sun, Tues, Thurs for a gym membership sheet
    By barnoonan in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-18-2011, 07:32 AM
  4. AD User Group membership Macro
    By Vincent.Eymard in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-14-2010, 11:05 PM
  5. Group membership
    By jamex in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 03-09-2006, 09:10 AM

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