extract the difference from two name lists

[rterrain03]

I need to compare two spread sheets and come up with the names that are not on both. any ideas ?

[NBVC]

use a helper formula like:

=Isnumber(match(a1,B:B,0))

where A1 is to be searched in column B... if a match occurs result is TRUE else it is FALSE

Then you can filter for the FALSE results and copy/paste elsewhere

[Fotis1991]

Hi
Take a look to the attach file.

Is this what are you looking for?

[rterrain03]

would that work for two different spread sheets ? and would i use that syntax exactly ? can i output it to a excel file ?

[rterrain03]

yes that looks good, can single click sort with that ?

[Fotis1991]

Sorry, but because English is not my first language, I did not understand your question.

Can you say it with other words?

[rterrain03]

what formula did you use for that

[Fotis1991]

If you look in Sheet 2, column B, you will see the formula(click on a cell there)

In any case the formula is:

Please Login or Register  to view this content.

Is it OK?

[sunflowers]

In cell B2 of sheet 2 enter this formula :

=LOOKUP(REPT("z",255),CHOOSE({1,2},"",INDEX($A$1:$A$7,MATCH(1,(COUNTIF($B$1:B1,$A$1:$A$7)=0)*(COUNTIF(Sheet1!$A$1:$A$7,Sheet2!$A$1:$A$7)=0),0)))) 

End by Crtl + shift + Enter
Plz, See attach file - thanks