comparing lists data

Public Schedule Face-to-Face & Virtual Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Comparing 2 lists of data

Comparing 2 lists of data

resolvedResolved · Low Priority · Version 365

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.xlsx

RE: 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


 

Excel tip:

Missing Field handle

If your field handle goes missing all you need to do is go to tools > options > edit tab and then make sure that the check boxes for paste and insert buttons are checked.

View all Excel hints and tips


Server loaded in 0.07 secs.

✓ w3speedster