Help needed matching table contents.

  • Thread starter Thread starter Chris Mitchell
  • Start date Start date
C

Chris Mitchell

I have 2 tables one large (L); 8000 rows by 200 columns, the other small(S),
5000 rows by 110 rows.

They share a common set of column row labels
There are some rows and columns in L that are completely blank and hence are
not represented in S.
S doesn't contain anything that is not in L.
S has some blank cells where the corresponding cell in L is populated.
In effect S is a sub set of L, but they are derived from different sources.
Cells in both contain either a "1" or are blank.

I want to be able to use the row and column labels of L to identify if and
where a match occurs in S and add the corresponding values so that cells in
the resultant are either blank, where both L & S are blank, 1 where L is 1
but S is blank, or 2 where both L & S are 1, S is 1 and L is blank doesn't
occur. In effect I want to 'stretch' S such that it fits and overlays L and
corresponding row and columns align, then drill down and sum the contents.

I have tried a variety of ways of doing this manually, but my machine grinds
to a halt or I make stupid mistakes. There must be a way of getting Excel
to do this, but how?

Any help would be greatly appreciated.

TIA.

Chris.
 
Thanks smartin. I'll probably go with Herbert's suggestion, but if that
fails I'll give yours a go.
 
Back
Top