Relatively easy data comparison Q?

G

Guest

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!
 
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

comparing lists 8
Updating Cells after comparing two worksheets 4
Data comparison showing detailed output 1
MS Excel VBA Copy and Paste from external workbook data to central worksheet 1
Replace all values in a column with values using a mapping from another worksheet 6
comparing a date range within another date range 1
Looping through delimited text and using VLOOKUP 5
Find values in table and return row/column name 7

Top