Hello, I've searched near and far for this and I've only come across a VBA solution.

Essentially I have 13,500 lines that include mobility users usage for a 6-month period separated by invoice date.

I've take the top 10 users of Long Distance Minutes from every month and compiled a list. Then i tool the list and did a count of how many times the number showed up over the 6-month period.

I want to filter the row label results of my pivot table to those specific 10-users. There are over 2500 users to manual process isn't efficient. I've looked to do this many times for other things but haven't found a solution yet.

I thought I may be able to use Kutools to Select specific cells and point a contains to a defined list =TopTenLD but cant get it to work... Lost

Thanks