Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
22
Views
Topic starter
What would be the easiest way of comparing the list content of two separate excel files for the same names, same data?
I have two files with a list of stock names and would like to know it the same stock name is contained in both files. I would also like to do the same on multiple files, e.g. over the last 3 months with weekly files (12 files).
How should I go about?
Thanks
Joachim
Posted : 14/09/2023 4:42 pm
Hi Joachim,
You can use Power Query to do this as explained here: Compare two Excel Lists with Power Query.
Mynda
Posted : 14/09/2023 7:34 pm