Comparing data on two worksheets and finding non matches

[JudeL]

Hi

I'm an Excel newbie so bear with me!

I have an Excel file with two worksheets in it. Both worksheets contain a list of names and various other bits of data.

What I need to do is compare the names in the two worksheets and find all the ones in Worksheet A that do not appear in Worksheet B and copy them into a new Worksheet C.

There must be a way to do this in Excel but the Help menus aren't giving much away!

Does anyone have any ideas? I'd be really grateful!
Jude

[JBeaucaire]

Let's say the names are in column A on both sheets. There needs to be "titles" in row 1, the data starting at row 2.

1) On SheetA put this formula in an empty cell on row2:
=ISNUMBER(MATCH(A1,SheetB!A:A,0))

2) Copy that down the whole data set. You now have a series of TRUE/FALSE answers.

3) Turn on Data > Filter > Autofilter

4) Filter the new column by "FALSE"

5) Copy all the visible rows (all at once) to SheetC

6) Turn off the Autofilter, delete the helper column (optional)

[JudeL]

Thanks JB, I'll give that a try!

[JBeaucaire]

If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].


(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated)