concatenateformulasgoogle sheetsgoogle-sheets-arrayformula
I have a table to combine text with conditions if in column A there is a duplicate number, then in the text in column B combined.
The formula that I have made like this:
=IF(COUNTIF($A:$A,A2)>1,TEXTJOIN(",",TRUE,B2:B),"")
But the results do not match, the results I want in column E.
You can do this with a regexmatch function using the custom formula option under the filter by condition options instead of starts with:
=regexmatch(A:A,"^Jury|^Something")
Explanation:
in regexes: the ^ means beginning of string/line and the | is the OR operator for regexes
={"Status"; ARRAYFORMULA(IF(LEN(A3:A),
IFERROR(VLOOKUP(A3:A, ARRAYFORMULA(SPLIT(QUERY(QUERY(QUERY(A3:A,
"select *", 0),
"select count(Col1), Col1 where Col1 is not null group by Col1 order by Col1", 0),
"select Col2 where Col1 >1", 0)&"♥Duplicate", "♥")), 2, 0), "No"), ))}
Best Answer