View Single Post
 
Old 10-21-2014, 07:54 AM
philipq philipq is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Oct 2014
Posts: 2
philipq is on a distinguished road
Default Multiple Label Criteria - Pivot Table

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
Attached Files
File Type: xlsx SAmple.xlsx (10.8 KB, 15 views)

Last edited by philipq; 10-21-2014 at 08:01 AM. Reason: Attachment
Reply With Quote