Identifying from lists

Hi Christine,

Thank you for the forum question.

Use a Table. Click inside the list of data. On the Insert tab on the Tables group click Table and click OK in the table tools dialog box.

Click inside the data in the table. Click the Design tab under Table Tools and tick Total Row. This will add a total row to the data. Click in total row under one of the columns and select count. When you filter the table on hair colour it will count how many with the specific hair colour.

I have attached an example file.


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