Excel code question

Question

I have 2 different excel files(all people and special people) that i want to kick special people from all people. Cant find a way.. if you don't understand check my example:

all people       special people
----------       --------------
1-john           1-john
2-jim            2-marry
3-mariah
4-russel
5-marry

I want:

all people     special people
----------     --------------
1-jim          1-john
2-mariah       2-marry
3-russel

Answer 1

use =COUNTIF() in normal people to identify those who are special. The sort on that column and delete the rows where the COUNTIF is not 0.