Identifying Missing entries from a list

[MjRmatt]

I have 2 lists of addresses on 2 different workbooks,

Both lists should have the same addresses, they dont.

How can I run a function that would identify where the lists differ?

Cheers

[davesexcel]

Hi MjRmatt ,

Take a look at the countif function,
Supply a sample workbook for a better explanation.

BTW: You have yet to reply to your two previous threads.

[JBeaucaire]

The construct I use for this is =ISNUMBER(MATCH())


=ISNUMBER(MATCH(Sheet1!A1, '[Book2.xls]Sheet1'!A:A, 0))

These formula will give you TRUE/FALSE answers.

[Marcol]

Try this in a spare column in Book1

Please Login or Register  to view this content.

Drag/Fill Down

Then in Book2

Please Login or Register  to view this content.

Drag/Fill Down

Then filter each sheet for "No Match"

Change Book1/Book2 to suit your workbook names.

Hope this helps