Count of temp and perm workers per month

[Remsnow]

Hi

Having used this board before I am sure this will be pretty simple for someone on here but I just can't figure it out!

I have the following columns; 'Working Month' (e.g. January 16), 'Membership Number', and 'Worker name', 'Agency Type' (Temp or Perm are the only two values,. On a summary page I want;

Column A: January 16, February, 16 etc
Column B: Temp (below the number of UNIQUE temp workers in that month)
Column C: Perm (below the number of UNIQUE perm workers in that month)

Is this possible please?

Any help is as always massively appreciated and will really help me at work!

Thanks!

 

[Remsnow]

I understand that the version of excel may make a difference. I am using excel 2007

Thanks

 

[AlanY]

deleted.

more tests required

 

[AlanY]

ok, try this

Excel 2013/2016
	A	B	C	D	E	F	G	H
1	Working Month	Membership Number	Worker name	Agency Type			Temp	Perm
2	January-16	102		Perm		January-16	3	3
3	January-16	102		Temp		February-16	4	2
4	January-16	101		Temp		March-16	0	0
5	January-16	104		Temp		April-16	0	0
6	January-16	104		Temp		May-16	2	4
7	January-16	101		Temp		June-16	0	0
8	January-16	105		Perm		July-16	0	0
9	January-16	104		Perm		August-16	0	0
10	February-16	101		Temp		September-16	0	0
11	February-16	105		Temp		October-16	0	0
12	February-16	102		Temp		November-16	0	0
13	February-16	104		Perm		December-16	0	0
14	February-16	102		Perm
15	February-16	105		Temp
16	February-16	104		Temp
17	May-16	102		Perm
18	May-16	102		Temp
19	May-16	104		Temp
20	May-16	103		Perm
21	May-16	104		Perm
22	May-16	101		Perm
Sheet1

Cell Formulas
Range	Formula
G2	{=SUM(--(FREQUENCY(IF($A$2:$A$22=$F2,IF($D$2:$D$22=G$1,$B$2:$B$22)),$B$2:$B$22)>0))}
Press CTRL+SHIFT+ENTER to enter array formulas.