Counting and Matching Multiple Values

[SarahShep]

I wonder if anyone can help me..................

We have 3 people performing 3 different activities and I need to flag up the tenth time each activity has taken place per person.

I have tried to use the sumproduct and countif formulas but they don't seem to work, I can get them to count the total amount of activities per person but I need to break it up per person, per activity.

For example..... I need the formula to flag up every 3rd time Katherine is Swimming or Running or Walking.

Column A Column B

Katherine Swimming
Laura Walking
Sarah Walking
Laura Walking
Laura Walking
Emma Running
Katherine Swimming
Sarah Running
Sarah Running
Laura Swimming
Katherine Running
Katherine Swimming
Katherine Running


Please help us sort this out as its driving crazy!!!!

Thanks

 

[fairwinds]

Hi,

Try:

=(MOD(SUMPRODUCT(($A$1:A1=$F$1)*($B$1:B1=$F$2)),$F$3)=0)*(A1=$F$1)*(B1=$F$2)

In C1 and drag down.

Book1
	A	B	C	D	E	F	G
1	Katherine	Swimming	0		Name	Laura
2	Laura	Walking	0		Activity	Walking
3	Sarah	Walking	0		Times	3
4	Laura	Walking	0
5	Laura	Walking	1
6	Emma	Running	0
7	Katherine	Swimming	0
8	Sarah	Running	0
9	Sarah	Running	0
10	Laura	Swimming	0
11	Katherine	Running	0
12	Katherine	Swimming	0
13	Katherine	Running	0
Sheet1

 

[SarahShep]

Thanks very much

 

[SarahShep]

Thanks very much