Compairing 2 PivotTables

  • Thread starter Thread starter johnb
  • Start date Start date
J

johnb

I have 2 list of data, 8k to 10k records in one and 500 to
1K in the other. Can I use a Pivottables to pick out the
small list where they occur within the big list? If so
pointers in the solution will be thankfully recieved.

TIA
johnb
 
The 2 lists come from different sources but have the same
fields. So I need to know when a record in list 1 appears
in List 2. I also need a report on which records occur in
both lists
 
Back
Top