How to Find Items in one column that are not in another column

Hi In my today task I need to search specific item from one column which are not present in other column

and while googling , I got below link
http://superuser.com/questions/81498/excel-find-items-in-one-column-that-are-not-in-another-column

1. Select the list in column A
2. Right-Click and select Name a Range...
3. Enter "ColumnToSearch"
4. Click cell C1
5. Enter this formula: =MATCH(B1,ColumnToSearch,0)
6. Drag the formula down for all items in B

If the formula fails to find a match, it will be marked #N/A, otherwise it will be a number.

If you'd like it to be TRUE for match and FALSE for no match, use this formula instead:

=IF(ISNA(MATCH(B1,ColumnToSearch,0)),FALSE,TRUE)

Hope it will help you people and save time...

Regards

Enjoy the day with lots of smile and happiness