the difference in the two Sheets pivot table to get this

tamer42

New Member
Joined
Aug 23, 2007
Messages
24
Hello,

There are two Sheets in a file, “Sheet1”, “Sheet2”

available on these Sheets the names of fruit ...

Sheet1:
Orange
Pear
Apple
Apricot
Cherry
Peach

Sheet2:
Tangerine
Orange
Pear
Banana
Cherry
Pomegranate
My question:
Can we provide a pivot table showing the difference in these two Sheets?

So in Sheet1 and Sheet2 is not on the, A pivot table will list the names of fruits

In summary, a pivot table will occur as follows;

Pivot Table:
Apple
Apricot
Cherry
Peach

Thank you in advance for your help,
good luck...
 

Some videos you may like

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

Richard Schollar

MrExcel MVP
Joined
Apr 19, 2005
Messages
23,707
How do you generate the Pivot Table output? Why is Cherry there but Pear is not? Can you verbally explain what you want to happen - also, would you mind a formula solution or does it have to be a pivot table?
 

tamer42

New Member
Joined
Aug 23, 2007
Messages
24
Mr. Richard Schollar;

How do you generate the Pivot Table output?

I can create a pivotTable report that uses ranges from one or more worksheets,
Pivot Table and PivotChart Wizard >>> Multiple consolidation ranges

But, I can’t create a pivotTable report that uses the difference of two worksheets

Why is Cherry there but Pear is not?

sorry, not a cherry
cherry on both pages registered

Not on the Sheet2: Apple, Apricot, Peach

Thank you, good luck.
 

Watch MrExcel Video

Forum statistics

Threads
1,128,022
Messages
5,628,186
Members
416,299
Latest member
arunvistas

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top