Counting Entries in two lists

[Guest]

Hello,

I have two lists on two sheets in one book (two lists were required because
I have about 85,000 records). One column in each list contains 'Class Codes'.
I want to produce a report that counts the combined total of each class codes
across both lists. The problem is that while most class codes occur in both
lists, there are some unique class codes in each list.

Is there a straight forward way of doing this? At the moment I am extracting
the unique values from each list, using conditional formats to find items
that occur in one list an not the other and then using the countif function
to sum each item. This works but it seems like the long way around this
problem.

Any help would be appreciated...

 

[Guest]

Thanks very much for this, I am familiar with pivot tables, have tried it and
it works. I seem to have a knack of finding quite complex solutions to
relatively simple problems.