# Multiple unique search returns

Copper Contributor

# 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?

2 Replies

# Re: Multiple unique search returns

What you've shared is a relatively complex formula. Speaking just for myself, I would find it easier to be confident of any suggestion I might have if I could test it first with the actual spreadsheet (or a reasonable mockup, if the actual contains confidential info).

You may be able to post such a copy on a reply to this message, assuming you see something like the following at the bottom of the message box.

# Re: Multiple unique search returns

If I understand your arrangement correctly, you could use:

My formula uses named items.

``````=LET(
line_break, CHAR(10),
crit, (Col_D = B3) * (Col_O = F1),
distinct, UNIQUE(FILTER(Col_K, crit, "None")),
TEXTJOIN(line_break, , distinct)
)``````