JumboCactuar
Well-known Member
- Joined
- Nov 16, 2016
- Messages
- 785
- Office Version
- 365
- Platform
- Windows
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
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