Forum Discussion
JoshuaThomas17
Sep 08, 2022Copper Contributor
Text join unique and filter
I have created an example of the data I am working with (below).
TEXTJOIN(" / ",1,UNIQUE(FILTER(A:A,B:B="CAR")))
This gives me A / B / C.
But group A CAR didn't make any after YR 1.
I am attempting to list all unique groups for a certain criteria if the group has a cumulative value over 0 from year 2 and out.
With the expected outcome to be B / C
| GROUP | TYPE | MAKE | YR 1 | YR 2 | YR 3 | YR 4 |
| A | CAR | FORD | 1 | 0 | 0 | 0 |
| A | TRUCK | CHEV | 1 | 2 | 3 | 5 |
| B | CAR | CHEV | 1 | 2 | 3 | 4 |
| B | CAR | FORD | 0 | 1 | 0 | 0 |
| C | TRUCK | CHEV | 1 | 2 | 0 | 3 |
| C | CAR | FORD | 0 | 2 | 3 | 4 |