You could add a column to the source table, and calculate which items
contain an "&". For example:

=IF(ISNUMBER(SEARCH("&",B2)),"Yes","No")

Then, add that field to the pivot table page area, and select "Yes" from
the dropdown list of items.

ushah wrote:
> Sure,
>
> This is what it looks like now,
> Description of item
> Description of Account
> TAPE: DOUBLE SIDED REFLECTIVE: Office Supplies
> TAPE: DOUBLE SIDED REFLECTIVE: Sum
>
> SPATULA: FISHER SCIENTIFIC #14 Office Supplies
> Office Supplies
>
> OFFICE SUPPLIES,CLEANER: FORD Equip Non-Proj.Main-Mach. &
> Office Supplies
> OFFICE SUPPLIES,CLEANER: FORD Sum
>
> So, I have 3 different item description Tape, Spatula & Office supplies
> cleaner. Out of that first two items only falls under one account description
> which is Office supply but the last and third item (Cleaner) falls under
> office supplies and Non-Proj.Main-Mach. description.
>
> I have about 1800 total items out of that may be 50 items used more than one
> account, and I wanted to find those items and list it by itself. Is it
> possible to do that? if so how?
> and thank you for your reply.
>
>
> "ushah" wrote:
>
>
>>I have file for different supplies, and other one for accout description
>>(that supplies were used under). Most supplies only appears under one account
>>only but there are some supplies that were used for more than one account
>>description. How can I just sort the supplies description so that it only
>>shows or it shows the one that were used for more than one account
>>description?
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html