Duplicates

Hi Charlie

We can achieve this by using Excel's advanced filter feature.

Click in your data to be filtered. Make sure each column of data has a data label at the top of it. From the Data menu choose Filter > Advanced filter

Excel will highlight the data table - make sure it has selected the data correctly. From the dialogue box that appears select to Filter the list in place then add a check mark to the Unique records only box.

Click on OK and Excel hides rows containing duplicate values.

I hope this helps - do let us know if you have any further questions.

Kind regards,
Andrew