Christine has attended:
Excel Introduction course
Multiple applications course
Excel VBA Intermediate course
Identifying from lists
I am trying to use excel to identify different information from a list which are related to a person. For example, a list of names in column A, their hair colour in the next column, age in the third, etc.
if I want to know how many people (and who from the list) have brown hair, how would I use excel to find that?
please can someone explain this to me?
Many thanks,
Christine
RE: 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
Attached files...
hair.xlsxRE: identifying from lists
Thank you, that was very helpful!
Christine
RE: identifying from lists
Hi Christine,
Pleasure to help. I am glad you could use my idea.
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
