Relatively easy data comparison Q?
 

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!

Relatively easy data comparison Q?
 

hi,
see this website
http://www.cpearson.com/excel/Duplicates.aspx

regards
FSt1

"Dan" wrote:

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!

Relatively easy data comparison Q?
 

Thanks, but this only talks about looking at repeating values in a single
column, rather than comparing between two disparate columns.


"FSt1" wrote:

hi,
see this website
http://www.cpearson.com/excel/Duplicates.aspx

regards
FSt1

"Dan" wrote:

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!