Is there away to compare the results of pivot tables?
Specifically, I had four data files which I imported to Excel (one data file per worksheet) and created four sets of pivot tables.
For example, I have four pivot tables (one for each extract file) which displays the names of individuals associated to a record. As such, is there a simple way (either through Excel commands or macros) that I can compare and create a tabular summary where I list all the unique names and indicate which extract has them?
PivotTable1 PivotTable2 PivotTable3
Name1 Y Y N
Name2 N Y N
Name3 N N N
Name4 N Y N