Julie has attended:
Excel Intermediate course
Excel Compare
Hello,
I would like to compare several tables on Excel to find their similarities and differences. How can I do this?
Thank you in advance!
Please have a look at Excel courses near me for more hands-on practice.
RE: Excel Compare
Hi Julie,
Thank you for the forum question.
If you in two or more tables have names and you want to find out if you have the same names many times a Countif function can help you. It can count have many times you have a specific name in multiple tables.
Conditional formatting can highlight all duplicates in the multiple tables.
Do you want to know if all tables have the same number of rows and columns you can use the Count function.
If you could let me know exactly which information you need from your tables I will be able to give you more precis answer.
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
