COUNTIF of Unique values with multiple criteria

[Jac3413]

I am trying to do a COUNTIF (and maybe that is not the correct function to use) of UNIQUE values based on multiple criteria (1) Location and (2) Level.

Multiple organizations report data based on the location and level of jobs. I need to show the "# of Unique Organizations Reporting" for any particular combination of locations & level...

For example, my data list looks like this

	A	B	C
1	Organization	Location	Level
2	Company A	TX	Junior
3	Company A	TX	Advanced
4	Company A	TX	Senior
5	Company A	CT	Advanced
6	Company A	CT	Intermediate
7	Company A	CT	Junior
8	Company A	CT	Senior
9	Company B	TX	Junior
10	Company B	TX	Advanced
11	Company B	CT	Intermediate
12	Company C	TX	Intermediate
13	Company C	TX	Advanced
14	Company C	CT	Junior
15	Company C	CT	Advanced
16	Company C	CT	Senior
17	Company D	TX	Junior
18	Company D	TX	Senior
19	Company D	CT	Intermediate

<tbody>
</tbody>

And I am trying to get a report that looks like this - looking for the formula I need for column C (however I have hundreds of rows of data with over 40 different locations, so I cannot manually count out to get the totals like I did for this example)

	A	B	C
1	Location	Level	# of Unique Org's Reporting
2	TX	Junior	3
3	TX	Intermediate	1
4	TX	Advanced	3
5	TX	Senior	2
6	CT	Junior	2
7	CT	Intermediate	3
8	CT	Advanced	2
9	CT	Senior	2

<tbody>
</tbody><colgroup><col><col><col></colgroup>

Help please! Thanks

 

[jbeaucaire]

This is the kind of thing a Pivot Table does in seconds...

Video: 2014-10-23_0809 - JerryBeaucaire's library