array formula or formula to return column data except for certain data.

Hi,

I have a list of 20 vehicle parts in a column A and I also have a list of 5 of the parts listed in column A in column B. Is there a formula that can return all the parts in column A except for those listed in column B?
So basically the list in column B can be found in column A but I only want the formula to return a the list in column A but the formula results should not return any of the list in column B.

Your help is much appreciated.

See attached file - is that what you are looking for?

Hope this helps.

Pete

Thank you Pete_UK, this is exactly the assistance I requested for.

Very much appreciated Sir.

You're welcome - thanks for the rep.

Pete