Advanced filter

Hi Andrew

Thank you for your question and welcome to the forum.

In previous versions of Excel, you would need to use the Advanced Filter to be able to do this.

In Excel 2007 there is a button that allows you to remove duplicates from a list on the Data ribbon - I haven't tried using it yet so test it first before you use it on any important data.

Kind regards
Amanda