I'm not sure. Best to have the OP's feedback to the thoughts. Anyway,
assuming your angle, it's always possible to do a backtest using the pivot
o/p.

Assuming the earlier pivot is now drawn from a combined source in a new
sheet, and the data for col A's uniques appears in A5 down, sums in B5 down
This backtest could be placed in C5:
=IF(AND(COUNTIF(Sheet1!A:A,A5),COUNTIF(Sheet2!A:A, A5)),B5,"")
with C5 copied down. An autofilter on col C could then be applied, and "(Non
blanks)" chosen to derive the result
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:21,000 Files:365 Subscribers:65
xdemechanik
---
"Emilio" wrote:
Max,
I dont think it would work because as he said, sheet1 ColA and sheet2 ColA
have the same data but not necessarily located in the same row. Sheet3
should scan Sheet1 ColA and sheet2 ColA for a match and if exists storing it
in sheet3 summing ColC of the match. Im not sure Excel can do this.
Cheers,
Emilio