I'd just cheat and concatenate each row into a cell.

=a1&"|"&b1&"|"&c1....
where | is a unique character that isn't in your data.

Then compare one column again.

Paul Zipko wrote:

Thanks, that site had what I needed to get started. Now what I'd like to
do is expand it so that instead of just comparing individual cells, it
compares rows from different tables that have the same structure. I've
tried changing the criteria in COUNTIF to a range but it just returned
zero's for every entry. I've also worked at getting the VBA macro
working but it's still coming back with a run time error when it tries
to compare the rows. Any help on this would be apreciate,

Paul

*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!

--

Dave Peterson