Nov 04 2021 09:07 AM - edited Nov 04 2021 10:29 AM
I am attempting to pull data dates from the data sheet onto the Region sheet based on the last meeting date on the data sheet.
I am only moderately familiar with writing formulas and that is why I am reaching out for help.
So, more more detail about the formula that I am trying to figure out.
Lets say for the date range on the Region sheet 1/1/21-1/31/21. If the Person ID from the Region Sheet matches the Person ID from the data Sheet, I would want the date that is between 1/1-1/31 input into the box next to that Person ID and between those date ranges automatically filled into the Region sheet as the data is placed on the Data Sheet as seen on the Region Page image below.
Nov 04 2021 09:43 AM - edited Nov 04 2021 10:07 AM
There is a big error in Table4: Thousands of empty rows.
In F1:
=TEXT(F3,"YYYYMM")
In F5:
=FILTER(Table4[Last Meeting Date],(Table4[Person Id]=$B5)*(TEXT(Table4[Last Meeting Date],"YYYYMM")=F$1),"")
Nov 04 2021 09:48 AM
Nov 04 2021 10:06 AM
Nov 04 2021 10:10 AM
Nov 04 2021 11:05 AM
Nov 04 2021 11:26 AM
Nov 04 2021 12:05 PM
@Detlef LewinSorry about that, because the dates end up being the same, I do not know which one is ending up in the actual cell.
Nov 04 2021 12:13 PM