In sheet2 cell B1 apply the below formula and copy down as required...Will
return names which are not there in Sheet1 ColA.

=IF(COUNTIF(Sheet1!A:A,A1),"",A1)

OR ' handling blank entries in ColA

=IF(OR(A1="",COUNTIF(Sheet1!A:A,A1)),"",A1)

--
Jacob (MVP - Excel)


"MMcGee" wrote:


I have 2 worksheets. Column A in sheet 1 contains values that I know are in
column A of sheet 2. I need only the rest of the values in sheet 2 (in other
words, the values that are NOT in sheet one).


Thanks!