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?

HOW TO GET FURTHER HELP WITH A WORKBOOK
For further help with it why not join our forums (shown in
the link below) it's completely free, if you do join you will have the
opportunity to *add attachmnets *to your posts so you can add workbooks
to better illustrate your problems and get help directly with them. Also
if you do join please post in this thread (link found below) so that
people who have been following or helping with this query can continue
to do so. :)


--
Pecoflyer

Cheers -

'Firefox 3.5' (http://www.mozilla.com/en-US/firefox/all-beta.html)
really IS fast !
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=113901