Text join unique and filter

Occasional Visitor

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 TYPEMAKEYR 1YR 2YR 3YR 4
A

CAR

FORD1000
ATRUCKCHEV1235
BCARCHEV1234
BCARFORD0100
CTRUCKCHEV1203
CCARFORD0234
1 Reply

@JoshuaThomas17 

 

=TEXTJOIN(" / ",TRUE,UNIQUE(FILTER(A2:A7,(B2:B7="CAR")*(E2:E7+F2:F7+G2:G7))))