Compare two columns

**zacharyz** · 12-19-2006, 12:27 PM

I am analyzing two columns.

In Column A, I have a list of all names.

In Column B, I have some, but not all the names from Column A

I need a third column (column C) to list all names in Column A that are not listed in Column B.

Here is the sample:

All Enrollees

Abbas, Tarek
Abelev, Nonna
Addeo, Lynne
Allegrini, Melissa
Amato, Geri
Ambrosino, Felicia
Anastasio, Joseph
Ansted, Amanda
Arnold, Georgia
Aschmies, Scott
Audier D'Alessandris, Marie
Avelar, Melanie
Ayala, Maritza
Azimov, Oleg

Employees w/ Usage

Abbas Tarek
Abelev Nonna
Addeo Lynne
Amato Geri
Ambrosino Felicia
Anastasio Joseph
Arnold Georgia
Aschmies Scott
Ayala Maritza

Thank you in advance.

**Carim** · 12-19-2006, 12:41 PM

Hi,

Take a look at a previous thread ...

HTH
Carim

**zacharyz** · 12-19-2006, 12:59 PM

I've tried...

**Carim** · 12-19-2006, 01:04 PM

VERY Sorry ... I forgot to copy the link ...

http://www.excelforum.com/showpost.p...31&postcount=2

HTH
Carim

**zacharyz** · 12-19-2006, 01:16 PM

I don't see how this sample relates to my question? Is there a specefic formula you can provide?

**Carim** · 12-19-2006, 01:20 PM

Hi again,

All possible formulae for comparison of two columns appear in second sheet column G,H,I ...

If you have difficulties adapting them, please upload a zipped copy of your worksheet ...

HTH
Carim