Multiple unique search returns

Hi I am using the below formula to find unique values in column KK if Column D:D = B3.

=LET(f,UNIQUE(FILTER('CEV - BRM View'!K:K,(ISNUMBER(SEARCH(B3,'CEV - BRM View'!D:D))))),TEXTJOIN(CHAR(10),TRUE,IF(f="","Blank",f)))

What I want to do is the same, find unique values in KK if column D:D = B3 and column O:O = F1

Can anyone help me?

Welcome to the forum.

Maybe:

Formula:

Please Login or Register  to view this content.

Good luck!