Removing data from a column?

I have 600 rows of data all containing domain names. 68 of the domain names have expired so i need to remove them from the list. They are in column A. Is there a way of removing these domains using a formula or do i need to delete 1 by 1 ?



Example

Column A

Car
Bus
Truck
Van
Lorry
Bike
Motorcycle
Red
Blue



Remove

Van
Lorry
Bike
Motorcycle

anyone got an answer

Assuming A2:A10 is housing the domains and B2:B5 is housing the expired domains, in another cell say, C2 enter this formula;

Please Login or Register  to view this content.