Multiple Label Criteria

Bruno Campanini · #5 11-27-2014, 09:06 AM

Quote:

Originally Posted by philipq

Greetings Friends,

Below shown is part of a pivot table.
The data range is actually huge to the range of 58,000 plus records.
These are call center data spooled from the server to excel.

Now, I need to filter only those in the labels that end with:-
FORD
JLR
FM
POC
FER
MAS

How do I go about doing so?

Can this be accomplished easily via some VBA method other than on a pivot.
Kindly refer attachment for the pivot table

Shouldn't you have any solution yet, may I put some questions for a VBA procedure:

1 - Does "-" always precede the suffix?
2 - do you want the selected records copied elsewhere or
do you want the unselected ones hidden?

Bruno

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Copy Multiple Rows to new workbook when multiple criteria is met.	flds	Excel Programming	5	09-30-2014 09:58 AM
VBA Pivot Table CubeField Enable multiple items	Wries	Excel Programming	0	03-13-2014 09:56 AM
Pivot table auto print. For multiple values.	Nicholaspoe	Excel	0	10-08-2013 09:08 PM
Ranking with multiple criteria	angie.chang	Excel	0	08-14-2012 04:49 PM
Multiple criteria in SUMIF?	pumpkin head	Excel	1	02-17-2006 09:06 AM