Lookup Name by Date ?

[JumboCactuar]

Hi,
not sure how to explain this:

I have a calendar like sheet
(Names in Column A going down the rows)
(Dates in Row 4 going Horizontal)

Then a Data sheet with names in Column A and Dates in Column B

I want to populate the calendar sheet for each Name with a count of records found for that Name/Date

Example
Data Sheet - John has 2 date entries for 24/01/2021

Calender - Column with that Date + Row with John = 2


Any help appreciated

 

[Toadstool]

Hi JumboCatuar,

Her the Data sheet

JumboCactuar2.xlsx
	A	B
1	Name	Date
2	Sue	01-Jan-21
3	Dave	02-Jan-21
4	Sue	03-Jan-21
5	Sarah	08-Jan-21
6	Dave	08-Jan-21
7	Dave	15-Jan-21
8	John	16-Jan-21
9	Sarah	17-Jan-21
10	John	05-Feb-21
Data

Here's the Calendar sheet

JumboCactuar2.xlsx
	A	B	C	D	E	F	G	H
4	Name	01-Jan-21	08-Jan-21	15-Jan-21	22-Jan-21	29-Jan-21	05-Feb-21	12-Feb-21
5	Dave	0	1	1	0	0	0	0
6	John	0	0	0	0	0	1	0
7	Sarah	0	1	0	0	0	0	0
8	Sue	1	0	0	0	0	0	0
Calendar

Cell Formulas
Range	Formula
B5:H8	B5	=COUNTIFS(Data!$A$2:$A$9999,Calendar!$A5,Data!$B$2:$B$9999,Calendar!B$4)

 

[JumboCactuar]

Hi JumboCatuar,

Her the Data sheet

JumboCactuar2.xlsx
	A	B
1	Name	Date
2	Sue	01-Jan-21
3	Dave	02-Jan-21
4	Sue	03-Jan-21
5	Sarah	08-Jan-21
6	Dave	08-Jan-21
7	Dave	15-Jan-21
8	John	16-Jan-21
9	Sarah	17-Jan-21
10	John	05-Feb-21
Data

Here's the Calendar sheet

JumboCactuar2.xlsx
	A	B	C	D	E	F	G	H
4	Name	01-Jan-21	08-Jan-21	15-Jan-21	22-Jan-21	29-Jan-21	05-Feb-21	12-Feb-21
5	Dave	0	1	1	0	0	0	0
6	John	0	0	0	0	0	1	0
7	Sarah	0	1	0	0	0	0	0
8	Sue	1	0	0	0	0	0	0
Calendar

Cell Formulas
Range	Formula
B5:H8	B5	=COUNTIFS(Data!$A$2:$A$9999,Calendar!$A5,Data!$B$2:$B$9999,Calendar!B$4)

working thankyou