Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Compare Data from two Worksheets | Excel Discussion (Misc queries) | |||
Compare several columns of data and display unique ones | Excel Discussion (Misc queries) | |||
compare data in 2 worksheets | Excel Worksheet Functions | |||
compare worksheets data | Excel Discussion (Misc queries) | |||
How do I compare 2 worksheets, 1 old, 1 updated to find difference | Excel Discussion (Misc queries) |