View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Vic Vic is offline
external usenet poster
 
Posts: 117
Default matching 2 worksheets to find differences

Can someone please help me with this task?

I have 2 worksheets I need to match to find entries that don't apprear in
the other worksheet. Worksheet3 shows rows from Worksheet1 that don't appear
in Worksheet2. Worksheet4 shows rows from Worksheet2 that don't appear in
Worksheet1.

Example:
worksheet1 worksheet2 worksheet3
worksheet4
A B C <= cols = A B C <= cols = A B C <= cols = A B C
a b 1 a b 1 a b 2
b n 1
a b 2 a b 3 c h 5
d f 3
a b 3 b n 1 d f 1
c h 3 c h 3
c h 5 c h 7
c h 7 d f 3
d f 1

Thank you,
Victor