pivot tables

[L]

I am trying to create a pivot table and compare from two worksheets.
Example.
Worksheet 1
A B C
1001 Apple 9999
1002 orange 9999
1003 banana 9999
1004 Cake 9999

Worksheet 2
A B C
1001 Apple 9999
1025 Cookie 8888
1003 banana 9999
1005 biscut 9999
1006 fries 9999

I need to compare all the 9999’s from Column C in both worksheets. I need
to know whether Worksheet 1 is missing any 9999’s from Worksheet 2, and vice
versa. I need it to calculate and show me all the duplicate food items of
9999 and the ones that are not.

Can someone please help?

Thanks.

 

[Herbert Seidenberg]

Pivot Table
Consolidate Ranges
Show duplicates
http://www.savefile.com/files/1634187