Forum Discussion
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?
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) )
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.
If not, put a copy on OneDrive or GoogleDrive and paste a link here that grants access to it,
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) )
