DOUBLE FILTER function to return ONLY records with most recent date

I got valuable input from @Fluff and @RoryA on a FILTER function to return ONLY records with most recent date

• I'm using Office 365
• I have a defined table named Table1 with headers and its data below. I added a helper column in M (Include Partner) with the formula: =XLOOKUP([@Partner],check!$A$2#,check!$B$2:$B$4) which checks if the checkbox for a certain partner is checked (TRUE) or unchecked (FALSE)
• In another sheet (called “check”), I have made a filter section for Partners in A2: =SORT(UNIQUE(Table1[Partner])) with inserted checkboxes (insert – cell controls) which are TRUE or FALSE
• I want a formula that filters on "Meeting" in column F (Type) so it returns only rows with "Meeting" and only shows the most recent date as per column G (Last) AND that filters on the ticked boxes from the Partners filter section (see previous bullet)

I have tried to change RoryA's formula which was:

=LET(

z, exampledata,

a, FILTER(z, INDEX(z, , 6) = "Meeting"),

uc, UNIQUE(INDEX(a,0,4)),

b, SORT(SORT(a, 4, ), 7,-1 ),

c,INDEX(b,0,4),

result,REDUCE("",uc,LAMBDA(a,i,VSTACK(a,TAKE(FILTER(b,c=i),1)))),

DROP(result,1)

)



And got as far as:

=VSTACK(

exampledata[#Headers],

LET(

z, exampledata,

a, SORT(SORT(FILTER(z, (INDEX(z, , 6) = "Meeting") * exampledata[Include Partner]), 4, 1), 7, -1),

uc, UNIQUE(INDEX(a, 0, 4)),

c, INDEX(a, 0, 4),

result, REDUCE("", uc, LAMBDA(a,i, VSTACK(a, TAKE(FILTER(a, c = i), 1)))),

DROP(result, 1)

)

)



Which returns a value error.

I’d appreciate if anyone can shine a light on this and maybe explain what I am doing wrong