Forum Discussion
Solved
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),TR...
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) )
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)
)