View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Brian Madsen Brian Madsen is offline
external usenet poster
 
Posts: 10
Default Matching rows for differences

I 'm in dire need of a solution to this problem, I need to match sheet1 to
sheet 2 by entire rows and show the non matching rows on sheet3. Any help
with this would be greatly appreciated. I've been working this for a week
and cannot come up with a solution.



Sheet 1 Sheet 2
Sheet3


1 2 3 4 1 2 3 4
6 7 8 8
2 3 4 5 2 3 4 5
6 7 8 9
6 7 8 9 6 7 8 8
e f g h
a b c d a b c d
e f h g
e f g h e f h g