Need help with Formula

%3CLINGO-SUB%20id%3D%22lingo-sub-2927567%22%20slang%3D%22en-US%22%3ENeed%20help%20with%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2927567%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20attempting%20to%20pull%20data%20dates%20from%20the%20data%20sheet%20onto%20the%20Region%20sheet%20based%20on%20the%20last%20meeting%20date%20on%20the%20data%20sheet.%3C%2FP%3E%3CP%3EI%20am%20only%20moderately%20familiar%20with%20writing%20formulas%20and%20that%20is%20why%20I%20am%20reaching%20out%20for%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%2C%20more%20more%20detail%20about%20the%20formula%20that%20I%20am%20trying%20to%20figure%20out.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELets%20say%20for%20the%20date%20range%20on%20the%20Region%20sheet%201%2F1%2F21-1%2F31%2F21.%20If%20the%20Person%20ID%20from%20the%20Region%20Sheet%20matches%20the%20Person%20ID%20from%20the%20data%20Sheet%2C%20I%20would%20want%20the%20date%20that%20is%20between%201%2F1-1%2F31%20input%20into%20the%20box%20next%20to%20that%20Person%20ID%20and%20between%20those%20date%20ranges%20automatically%20filled%20into%20the%20Region%20sheet%20as%20the%20data%20is%20placed%20on%20the%20Data%20Sheet%20as%20seen%20on%20the%20Region%20Page%20image%20below.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2927567%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2927707%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20help%20with%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2927707%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1207177%22%20target%3D%22_blank%22%3E%40Icemank83%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere%20is%20a%20big%20error%20in%26nbsp%3BTable4%3A%20Thousands%20of%20empty%20rows.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20F1%3A%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel-formula%22%3E%3CCODE%3E%3DTEXT(F3%2C%22JJJJMM%22)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3EIn%20F5%3A%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3E%3DFILTER(Table4%5BLast%20Meeting%20Date%5D%2C(Table4%5BPerson%20Id%5D%3D%24B5)*(TEXT(Table4%5BLast%20Meeting%20Date%5D%2C%22JJJJMM%22)%3DF%241)%2C%22%22)%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2927733%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20help%20with%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2927733%22%20slang%3D%22en-US%22%3EThere%20are%20so%20many%20empty%20rows%2C%20because%20there%20will%20be%20tons%20of%20data%20input%20into%20the%20table%20through%20the%20course%20of%20the%20year.%20Should%20those%20be%20deleted%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2927826%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20help%20with%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2927826%22%20slang%3D%22en-US%22%3EI%20tried%20the%20formula%20above%2C%20I%20got%20the%20output%20of%201%2F0%2F00%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2927831%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20help%20with%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2927831%22%20slang%3D%22en-US%22%3EI%20changed%20my%20reply.%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

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. 

9 Replies

@Icemank83 

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),"")

 

There are so many empty rows, because there will be tons of data input into the table through the course of the year. Should those be deleted?
I tried the formula above, I got the output of 1/0/00
I changed my reply.
Yes. A table must not contain empty rows. If there will be new data you have to append it to the table.
Okay, got that. When there are multiples of the same date coming up, how do you keep the data from spilling into the next row. Is the only way to delete the repeat data?
You didn't mention this fact before.
If there are four dates in the result would you get the first, the last, the smallest, the largest or all of them in one cell?

@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.

If the dates are always identical put MIN() or MAX() around the formula.