Hi all,

I have a document I need to do.

I have 2 xls doc sheets. Both docs have 2 colums, 1st is the US state,
the second is the City. I need to build a table that will tell me how
many rows (State and City) matches between the 2 sheets and if
possible:

Build a table showing how many matches and how many dont,
list the ones that dont,
build a chart

How can I do this? I dont even know where to start....

The 1 sheet is the master, has 200 or so rows that the other sheet must
match against.

Thanks for any help you can provide me.


--
npereira
------------------------------------------------------------------------
npereira's Profile: http://www.excelforum.com/member.php...o&userid=10799
View this thread: http://www.excelforum.com/showthread...hreadid=570506