Return values from a cell of values separated by commas that do not match a set of specified values listed within a separate column

[anthx]

Hi, I have cells with IP addresses that are separated by commas and I want to return only the IP addresses separated by commas that do not match any of the IP addresses I've specified within a separate column. I've attached a picture of a simplified setup. I was able to create a function to return all of the matches, but now I want to return all of the IP addresses that do not match. I want to return the IP addresses that do not match from the cells with IP addresses separated by commas, not the IP addresses listed within the column. Please let me know if I can clarify anything or additional information would be useful.

 

[Fluff]

How about

=BYROW(TRIMRANGE(B2:B1000),LAMBDA(br,LET(a,TEXTSPLIT(br,", "),ARRAYTOTEXT(FILTER(a,ISNA(XMATCH(a,A2:A10)))))))

 

[anthx]

How about

=BYROW(TRIMRANGE(B2:B1000),LAMBDA(br,LET(a,TEXTSPLIT(br,", "),ARRAYTOTEXT(FILTER(a,ISNA(XMATCH(a,A2:A10)))))))

Yes, this worked perfectly! Thank you for the quick solution!

 

[Fluff]

You're welcome & thanks for the feedback.