Evelyn has attended:
Excel Intermediate course
Comparing 2 lists of data
I work with student data and often would like to see whether the same students take part in 2 separate modules. It can be a few hundred students, which makes it difficult to do manually. I would therefore like Excel to compare 2 lists of names for me and tell me who is not in which original list. How would I do that?
RE: Comparing 2 lists of data
Hi Evelyn,
Thank you for the forum question.
I have attached and Excel file. I have used 3 different to compare lists.
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...
compare lists.xlsxRE: Comparing 2 lists of data
Hi Jens,
So sorry, I can't seem to find the excel file.
Where is it?
Many thanks,
Evelyn
RE: Comparing 2 lists of data
Hi Evelyn,
If you look at my previous reply all way under my signature and contact details, you should be able to see the attached file. If it is not there refresh you browser.
Otherwise if you give me your email address, I will send it t you.
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
