COMPARING LISTS
 

Column B contains a list of names and so does column D.
I need a code that will compare the two list in this way:
Any name in column B that is not in column D should be listed in
column C.

Thanks in advance for your help.

Jay dean


*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!

COMPARING LISTS
 

Jay

One way:

=IF(ISNA(VLOOKUP(B2,D:D,1,FALSE)),B2,"")

Regards

Trevor


"jay dean" wrote in message
...


Column B contains a list of names and so does column D.
I need a code that will compare the two list in this way:
Any name in column B that is not in column D should be listed in
column C.

Thanks in advance for your help.

Jay dean


*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!

COMPARING LISTS
 

Hi
in C1 enter the formula
=IF(COUNTIF($D$1:$D$1000,B1),"",B1)
and copy down

--
Regards
Frank Kabel
Frankfurt, Germany


jay dean wrote:
Column B contains a list of names and so does column D.
I need a code that will compare the two list in this way:
Any name in column B that is not in column D should be listed in
column C.

Thanks in advance for your help.

Jay dean


*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!

COMPARING LISTS
 

Thanks, Frank and Trevor!

Jay Dean


*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!