Relative newbie with Excel, so excuse what may be a very simple question,
thanks in advance for the help.

I have a "worksheet A" with a column of about 1200 IDs consisting of 10
characters; some of these 10 characters are numbers, some are text.

Another "worksheet B" in the same file has a similar column of about 2300 of
these IDs, also containing both alpha and numeric characters.

I want to compare the column of IDs in worksheet B with those in worksheet
A, and find out which ones match and which ones don't, essentially de-duping
these two lists to find unique and non-unique IDs.

Seems like this can be handled relatively easily with a lookup function or
conditional formatting, but as I said, I'm a newb.

TIA!