Number of times a name appears against separate dates

[William53]

Hi All
I am trying to work out a formula that counts the number of times a persons name appears in a table against separate dates. E.g., a name can appear on a specific date say 23rd Feb. 2022 6 times then appear again on the 26th May 2002 7 times. I want to be able to just count the name twice. Any help with this would be gratefully received. Example table below:

1​	Jane	23-Feb-22​	Wed	Feb	22
2​	Jane	23-Feb-22​	Wed	Feb	22
3​	Jane	23-Feb-22​	Wed	Feb	22
4​	Jane	23-Feb-22​	Wed	Feb	22
5​	Jane	23-Feb-22​	Wed	Feb	22
6​	Jane	27-Feb-22​	Sun	Feb	22
7​	Eddie	17-Mar-22​	Thu	Mar	22
8​	Eddie	17-Mar-22​	Thu	Mar	22
9​	Eddie	17-Mar-22​	Thu	Mar	22
10​	Eddie	17-Mar-22​	Thu	Mar	22
11​	Eddie	17-Mar-22​	Thu	Mar	22
12​	Eddie	17-Mar-22​	Thu	Mar	22
13​	Eddie	17-Mar-22​	Thu	Mar	22
14​	Eddie	17-Mar-22​	Thu	Mar	22
15​	Eddie	17-Mar-22​	Thu	Mar	22
16​	Eddie	17-Mar-22​	Thu	Mar	22
17​	Eddie	17-Mar-22​	Thu	Mar	22
18​	Jane	26-May-22​	Thu	May	22
19​	Jane	26-May-22​	Thu	May	22
20​	Jane	26-May-22​	Thu	May	22
21​	Jane	26-May-22​	Thu	May	22
22​	Jane	26-May-22​	Thu	May	22
23​	Jane	26-May-22​	Thu	May	22
24​	Jane	26-May-22​	Thu	May	22
25​	Jane	26-May-22​	Thu	May	22
26​	Jane	26-May-22​	Thu	May	22
27​	Jane	26-May-22​	Thu	May	22
28​	Eddie	01-Jun-22​	Wed	Jun	22
29​	Eddie	01-Jun-22​	Wed	Jun	22
30​	Eddie	01-Jun-22​	Wed	Jun	22
31​	Eddie	01-Jun-22​	Wed	Jun	22

 

[Fluff]

How about

Fluff.xlsm
	A	B	C	D	E	F	G	H	I
1
2	1	Jane	23-Feb-22	Wed	Feb	22		Jane	3
3	2	Jane	23-Feb-22	Wed	Feb	22		Eddie	2
4	3	Jane	23-Feb-22	Wed	Feb	22
5	4	Jane	23-Feb-22	Wed	Feb	22
6	5	Jane	23-Feb-22	Wed	Feb	22
7	6	Jane	27-Feb-22	Sun	Feb	22
8	7	Eddie	17-Mar-22	Thu	Mar	22
9	8	Eddie	17-Mar-22	Thu	Mar	22
10	9	Eddie	17-Mar-22	Thu	Mar	22
11	10	Eddie	17-Mar-22	Thu	Mar	22
12	11	Eddie	17-Mar-22	Thu	Mar	22
13	12	Eddie	17-Mar-22	Thu	Mar	22
14	13	Eddie	17-Mar-22	Thu	Mar	22
15	14	Eddie	17-Mar-22	Thu	Mar	22
16	15	Eddie	17-Mar-22	Thu	Mar	22
17	16	Eddie	17-Mar-22	Thu	Mar	22
18	17	Eddie	17-Mar-22	Thu	Mar	22
19	18	Jane	26-May-22	Thu	May	22
20	19	Jane	26-May-22	Thu	May	22
21	20	Jane	26-May-22	Thu	May	22
22	21	Jane	26-May-22	Thu	May	22
23	22	Jane	26-May-22	Thu	May	22
24	23	Jane	26-May-22	Thu	May	22
25	24	Jane	26-May-22	Thu	May	22
26	25	Jane	26-May-22	Thu	May	22
27	26	Jane	26-May-22	Thu	May	22
28	27	Jane	26-May-22	Thu	May	22
29	28	Eddie	01-Jun-22	Wed	Jun	22
30	29	Eddie	01-Jun-22	Wed	Jun	22
31	30	Eddie	01-Jun-22	Wed	Jun	22
32	31	Eddie	01-Jun-22	Wed	Jun	22
33
Master

Cell Formulas
Range	Formula
H2:H3	H2	=UNIQUE(FILTER(B2:B100,B2:B100<>""))
I2:I3	I2	=ROWS(UNIQUE(FILTER($C$2:$C$100,$B$2:$B$100=H2)))
Dynamic array formulas.

 

[William53]

How about

Fluff.xlsm
	A	B	C	D	E	F	G	H	I
1
2	1	Jane	23-Feb-22	Wed	Feb	22		Jane	3
3	2	Jane	23-Feb-22	Wed	Feb	22		Eddie	2
4	3	Jane	23-Feb-22	Wed	Feb	22
5	4	Jane	23-Feb-22	Wed	Feb	22
6	5	Jane	23-Feb-22	Wed	Feb	22
7	6	Jane	27-Feb-22	Sun	Feb	22
8	7	Eddie	17-Mar-22	Thu	Mar	22
9	8	Eddie	17-Mar-22	Thu	Mar	22
10	9	Eddie	17-Mar-22	Thu	Mar	22
11	10	Eddie	17-Mar-22	Thu	Mar	22
12	11	Eddie	17-Mar-22	Thu	Mar	22
13	12	Eddie	17-Mar-22	Thu	Mar	22
14	13	Eddie	17-Mar-22	Thu	Mar	22
15	14	Eddie	17-Mar-22	Thu	Mar	22
16	15	Eddie	17-Mar-22	Thu	Mar	22
17	16	Eddie	17-Mar-22	Thu	Mar	22
18	17	Eddie	17-Mar-22	Thu	Mar	22
19	18	Jane	26-May-22	Thu	May	22
20	19	Jane	26-May-22	Thu	May	22
21	20	Jane	26-May-22	Thu	May	22
22	21	Jane	26-May-22	Thu	May	22
23	22	Jane	26-May-22	Thu	May	22
24	23	Jane	26-May-22	Thu	May	22
25	24	Jane	26-May-22	Thu	May	22
26	25	Jane	26-May-22	Thu	May	22
27	26	Jane	26-May-22	Thu	May	22
28	27	Jane	26-May-22	Thu	May	22
29	28	Eddie	01-Jun-22	Wed	Jun	22
30	29	Eddie	01-Jun-22	Wed	Jun	22
31	30	Eddie	01-Jun-22	Wed	Jun	22
32	31	Eddie	01-Jun-22	Wed	Jun	22
33
Master

Cell Formulas
Range	Formula
H2:H3	H2	=UNIQUE(FILTER(B2:B100,B2:B100<>""))
I2:I3	I2	=ROWS(UNIQUE(FILTER($C$2:$C$100,$B$2:$B$100=H2)))
Dynamic array formulas.

Many thanks Fluff, once again you have EXCELled, works perfectly.

 

[Fluff]

You're welcome & thanks for the feedback.