Davy,

I'd use Advanced Filter. Highlight the range with your data and click DataAdvanced (from the Sort & Filter group). You may either filter the list in place or copy it to a new location in your workbook. Ignore the criteria range,and fill in the "Copy to" range if you are putting the results elsewhere in your book. Finally, be sure to check the box for "Unique records only" and click OK.

Hope this helps,

Ben