Forum Discussion
Comparing two large excel sheets
I have two large excel files. I have to to combine the two files to see who is missing from the first file to the second file. The files are mostly the same besides a handful of differences. I can...
Gluksker I'd look into Power Query (as long as you are not on a Mac). Ideal to connect to large data sets without loading everything into a workbook and merge these data sets mimicking VLOOKUP, with the possibility to not only find matching records, but also find the ones that don't. Would be helpful if you could share a representative sample of your data sets to demonstrate it.