98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Comparing 2 lists of data
Comparing 2 lists of data
Resolved · Low Priority · Version 365
Mon 17 Jun 2024, 16:23Delegate Evelyn said...
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?
Fri 21 Jun 2024, 14:01Trainer Jens said...
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.xlsxThu 27 Jun 2024, 15:52Delegate Evelyn said...
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
Fri 28 Jun 2024, 09:02Trainer Jens said...
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
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Missing Field handleIf 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. |
