Look Up and Count

[philb99]

Hi - I have two columns of data that I report each month - Col A = Staff Name Col B = Course Name

This represents staff who have not completed a course.

I wish to know how many months they have failed to complete the course, for example if they on the list for January, February and March then that would record 3 when I look at March output

Thank you

 

[awoohaw]

I think you need to give a sample of what your data looks like. The xl2bb add in link is below.
Your question has many questions before anyone can give an answer.
The reader can interpret this many different ways.

 

[awoohaw]

nevermind

 

[awoohaw]

You can combine the columns and put the data into a pivot table:

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1	January	Course	February	Course	March	Course		Name	Course		Count of Course	Column Labels
2	Name1	History	Name3	Writing	Name5	Algebra		Name1	History		Row Labels	Algebra	Art	History	Science	Writing	Grand Total
3	Name2	Algebra	Name4	Art	Name6	History		Name2	Algebra		Name1			1			1
4	Name3	Art	Name5	Art	Name4	Science		Name3	Art		Name10					1	1
5	Name4	Science	Name6	Science	Name5	Art		Name4	Science		Name2	1					1
6	Name5	Art	Name7	Algebra	Name9	Science		Name5	Art		Name3		1			1	2
7	Name6	Algebra	Name8	History	Name10	Writing		Name6	Algebra		Name4		1		2		3
8								Name3	Writing		Name5	1	3				4
9								Name4	Art		Name6	1		1	1		3
10								Name5	Art		Name7	1					1
11								Name6	Science		Name8			1			1
12								Name7	Algebra		Name9				1		1
13								Name8	History		Grand Total	4	5	3	4	2	18
14								Name5	Algebra
15								Name6	History
16								Name4	Science
17								Name5	Art
18								Name9	Science
19								Name10	Writing
20
Sheet1