Compare 1 column to another
 

I want to formulate a list of value that are in column A and not in column B.
I'm comparing 2 lists of employee IDs. I'm going to do this many times, so
the exact number of IDs in either column will change. I don't know if this
makes a difference or not.

Thanks in advance,
Clint

Compare 1 column to another
 

try it

http://www.j-walk.com/ss/excel/usertips/tip073.htm


hth
regards from Brazil
Marcelo

"cherman" escreveu:

I want to formulate a list of value that are in column A and not in column B.
I'm comparing 2 lists of employee IDs. I'm going to do this many times, so
the exact number of IDs in either column will change. I don't know if this
makes a difference or not.

Thanks in advance,
Clint