Unique Count with criteria under a distriubtion matrix

silentbuddha

Board Regular
Joined
Mar 1, 2008
Messages
112
Hi All,

I'm trying to figure out how to solve this Unique Count situation based on multiple criteria

Scenario: we have agents from different departments who produce different sales on different plan rates

Raw Data
EmployeePlan RatePayout pts
12050
110100
230200
330200

<tbody>
</tbody>


Matrix

Matrix
Plan Rates
Plan Rates
Plan Rates
Plan Rates
0102030
Sales Volume bucket
1count of unique # of employees who made one sale on a plan_rate of 10.
Sales Volume bucket
2count of unique # of employees who made two sales on a plan_rate of 20.
Sales Volume bucket
3count of unique # of employees who made three sales on a plan_rate of 30.

<tbody>
</tbody>


Thanks :eek:
 
Last edited:

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.
Hi Neon,

I just want a to know what formula I need in order to answer fill in the values within the matrix that i posted above.

my apologies if I was not clear in my original post.

Thanks
 
Upvote 0
Hi All,

Would anyone be able to point in me the right direction as to how I would need to approach this problem and solve it ?

thanks and much appreciated
 
Upvote 0
Hi Aladin,

my apologies for the late reply...for simplicity purposes...assume that each row of data in my original RAW DATA table is a sale. merci
 
Upvote 0
Hi Aladin
rate 0
rate 10
rate 20
rate 30
1 sale
0
0
0
0
2 sales
0
emp_1
--------
total count of employees = 1
emp_1
emp_2
--------
total count of employees = 2
0
3 sales
0
0
0
emp_3
--------
total count of employees = 1

<tbody>
</tbody>

Thanks:cool:
 
Upvote 0
Hi Aladin
rate 0
rate 10
rate 20
rate 30
1 sale
2 sales
emp_1
--------
total count of employees = 1
emp_1
emp_2
--------
total count of employees = 2
3 sales
emp_3
--------
total count of employees = 1

<TBODY>
</TBODY>

Thanks:cool:

How do you obtain 2 for 2 sales x rate 20?
 
Upvote 0
rate 0
rate 10
rate 20
rate 30
1 sales
0
0
0
emp_2
--------
total count of employees = 1
2 sales
0
emp_1
--------
total count of employees = 1
emp_1
--------
total count of employees = 1
0
3 sales
0
0
0
emp_3
--------
total count of employees = 1

<tbody>
</tbody>

Hi Aladin,

my aplogies, the above table shold be the output I am hoping to achieve...thanks :)
 
Upvote 0

Forum statistics

Threads
1,213,524
Messages
6,114,117
Members
448,549
Latest member
brianhfield

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top