I have a list of 7 columns. Account number is the first colum and they are
all in order. Column 2 is the account name, and column 3 is the business
industry. I want to get all the companies that are in the Manufacturing
industry so i created a pivot table for that. Then i get a pivot table for
all the companies in the services industry and it populates. However, in
some cases, companies are listed in both industries. I have filtered my
worksheet and all of the companies are in the correct industry. Any idea why
it would be putting them into two differnt industies?