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?

Can you give an example of how your pivot table appears now, and how
you'd like it to appear?

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

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?

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