Duplicates

Hi Geraint,

Thank you for the forum question and for the nice feedback. I am happy that you found the course useful.

I hope, I fully understand what you want to do.

I have done some examples (please find attached Excel file). In the first table I have added conditional formatting to highlight duplicates and added a TOTAL ROW to the dynamic table (you can find this option under the TABLE DESIGN tab when you click inside the dynamic table) and changed the TOTAL row to COUNT. Then the table has been filtered BY COLOUR and the total row will show that there is 11 duplicates.

In the second below you can find Excel functions all highlighted in yellow.

I hope this can be helpful.

If you cannot find the attached file refresh your browser and if you still cannot see it below my reply, please wait 10 minutes and try again. Sometimes it takes some time after it is uploaded.


Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector