Thanks for the reply. Lists are part numbers, number of of entries sometimes
quite long, over 1000 lines. Not sure if Access or Excel has a easy command
to accomplish.


"T. Valko" wrote:

Does one column have more data than the other? (you only need to check the
shortest column)

What type of data are we talking about, text, numbers, both?

Biff

"Doug C" wrote in message
...
I would like to compare the values in two columns in a spreadsheet, and
find
the values that are common to both columns, and output those values to a
new
column.