LinkBack URL
About LinkBacks
Pietzki 
Please try in E4 and copy down:Formula:
=IF([@[Newstarters by specialisation]]="","",LET(t,'Training lists'!B$3:B$5,TEXTJOIN(", ",,FILTER(t,ISNA(XMATCH(t,Table1[@[02-Jan-24]:[31-Dec-24]])),"-"))))
Please try in E4 and copy down:Formula:=IF([@[Newstarters by specialisation]]="","",LET(t,'Training lists'!B$3:B$5,TEXTJOIN(", ",,FILTER(t,ISNA(XMATCH(t,Table1[@[02-Jan-24]:[31-Dec-24]])),"-"))))
Thank you, that looks perfect actually! I will mark the thread as resolved - if there's any issue when I implement at full scale I may report back.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks