Filter mulitple rows by matching data in one column

[JulianpIDG]

I have an grid of data where we have many companies listed many times for different transactions all of which have a location of the transaction. I woud like to find a list of all companies who have never had a transaction in England but have done so elsewhere.
ie

ABC Ltd	Scotland
ABC Ltd	England
ABC Ltd	Wales
ABC Ltd	Ireland
DEF Ltd	Scotland
DEF Ltd	Wales

In this sheet I would be looking to return a result of DEF Ltd as across all rows they do not have any records in England. Please can someone asssist in the correct formula or use of pivot table? Thank you in advance

[#2]

@JulianpIDG Since you mention "many companies listed", you may consider PowerQuery (if you're not a Mac). Alternatively, if you are an MS365 subscriber, you can do it in a few steps with UNIQUE, FILTER. Working examples in the attached workbook.