Sep 08 2022 08:57 AM
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 |
Sep 08 2022 01:38 PM