Google Sheets - FILTER Formula

[krispartsbadger]

In my Data Set tab I have a bunch of sales reps and their orders. I'm trying to combine the sales that don't have many sales into the same filter. So for this example I have RD sales which was none. BB sales has 1 line item. DD has 2 line items. Is there a way to have the formula filter the RD, BB and DD onto this tab?

 

[Fluff]

can you post your current formula.

 

[krispartsbadger]

=FILTER('Data Set'!A1:J,'Data Set'!A1:A="RD")

 

[Fluff]

Thanks for that.
How about

=FILTER('Data Set'!A1:J,('Data Set'!A1:A="RD")+('Data Set'!A1:A="BB")+('Data Set'!A1:A="DD"))

 

[krispartsbadger]

Thanks for that.
How about

=FILTER('Data Set'!A1:J,('Data Set'!A1:A="RD")+('Data Set'!A1:A="BB")+('Data Set'!A1:A="DD"))

Beautiful! Thank you!

 

[Fluff]

You're welcome & thanks for the feedback.