Count number of unique values with multiple criteria

JAC_OGG

New Member
Joined
Oct 22, 2013
Messages
2
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?
 

Some videos you may like

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
45,255
Office Version
365
Platform
Windows
Welcome to posting at the MrExcel board!

See if you can make use of this thread
 
Last edited:

JAC_OGG

New Member
Joined
Oct 22, 2013
Messages
2
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
 

Watch MrExcel Video

Forum statistics

Threads
1,102,729
Messages
5,488,535
Members
407,643
Latest member
samerf86

This Week's Hot Topics

  • Timer in VBA - Stop, Start, Pause and Reset
    [CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub...
  • how to updates multiple rows in muliselect listbox
    Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code...
  • Delete Row from Table
    I am trying to delete a row from a table using VBA using a named range to find what I need to delete. My Range is finding the right cell. In the...
  • Assigning to a variable
    I have a for each block where I want to assign the value in column 5 of the found row to the variable Serv. [CODE=vba] For Each ws In...
  • Way to verify information
    Hi All, I don't know what to call this formula, and therefore can't search. I have a spreadsheet with information I want to reference...
  • Active Cell Address – Inactive Sheet
    How to use VBA to get the cell address of the active cell in an inactive worksheet and then place that cell address in a location on the current...
Top