COMPARING LISTS

[jay dean]

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!

 

[Trevor Shuttleworth]

Jay

One way:

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

Regards

Trevor

 

[Frank Kabel]

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

 

[jay dean]

Thanks, Frank and Trevor!

Jay Dean


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