Count number of unique values with multiple criteria
Results 1 to 3 of 3

Thread: Count number of unique values with multiple criteria
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Oct 2013
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Count number of unique values with multiple criteria

    Morning all

    I'm struggling with coming up with a formula to count the number of managers in a list.

    I have a dataset that includes week numbers, regions, deals and managers. I need to come up with a count of managers for a specific week and region. I keep coming back with the overall count, I can't seem to narrow it down to unique manager occurrences. Any Suggestions?

  2. #2
    MrExcel MVP
    Moderator
    Peter_SSs's Avatar
    Join Date
    May 2005
    Location
    Macksville, Australia
    Posts
    40,339
    Post Thanks / Like
    Mentioned
    86 Post(s)
    Tagged
    19 Thread(s)

    Default Re: Count number of unique values with multiple criteria

    Welcome to posting at the MrExcel board!

    See if you can make use of this thread
    Last edited by Peter_SSs; Jul 24th, 2019 at 05:57 AM.
    Hope this helps, good luck.
    Peter
    Excel 365 - Windows 10
    - Want to help your helpers by posting a small, copyable, screen shot directly in your post? Look here
    - If posting vba code, please use Code Tags - like this [code]Paste code here[/code] - or use the VBHTML Maker
    - Read: Forum Rules, Forum Use Guidelines, & FAQ

  3. #3
    New Member
    Join Date
    Oct 2013
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Count number of unique values with multiple criteria

    I think that's close. Hopefully the below sample will help describe what I'm looking for.

    A B C
    1 WK42
    2 Deals Managers
    3 Central Lancs & Stafford 0 0
    4 Central Yorkshire 2 1
    5 East England 1 1
    6 East Scotland 0 0
    7 London & South East 0 0
    8 Manchester & Merseyside 0 0
    9 North Scotland 0 0
    10 North Yorkshire, Hull & North East 2 1
    11 South Scotland & North Cumbria 0 0
    12 Thames Valley, Gloucester & West Midlands 1 1
    13 West Scotland 0 0



    A B C
    1 Area Wk Manager
    2 North Yorkshire, Hull & North East WK42 AA
    3 North Yorkshire, Hull & North East WK42 AA
    4 Central Yorkshire WK42 BB
    5 Central Yorkshire WK42 BB
    6 East England WK42 CC
    7 Thames Valley, Gloucester & West Midlands WK42 DD

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •