Pivot Table options

[JinxedCaspa]

Hi all I have a huge file that I require to develop a pivot table for.

I require information on the customers that are on a service type 2, 8, and or 7 this is denoted by a number in column J (PMP Type) = 2, 8 or 7

I also require the information on the customers that are on a service type 4 column J - but only if their customer number in column Q is duplicated 10 or more times

Is that possible?

 

[JinxedCaspa]

A

Hi all I have a huge file that I require to develop a pivot table for.

I require information on the customers that are on a service type 2, 8, and or 7 this is denoted by a number in column J (PMP Type) = 2, 8 or 7

I also require the information on the customers that are on a service type 4 column J - but only if their customer number in column Q is duplicated 10 or more times

I have run a conditional formats the customer numbers that repeat 10+ times but my Laptop is constantly freezing when trying to sort it to delete the unneeded data

Is that possible?