View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
auntiespyke auntiespyke is offline
external usenet poster
 
Posts: 3
Default Compare data from two worksheets and display difference into 3rd s

Hi,
I'm trying to compare names in two worksheets and display unmatching names
on a third worksheet.

WS#1 compares a new list of names in column A to WS#2 which is the old list
of names in column A. I want to pull the names that are in WS#1 that are not
in WS#2 and display those new names onto WS#3 in column A.

I've tried what I can using LOOKUP and IF-AND-OR, but apparently don't know
what I'm doing since it won't work.

Thanks for your help.