how to compare values between 2 tables in excel

[Anonymous]

I have an excel output table 80 colmn X 50 rows that needs to be compared against another identical table every month. is there a way to compare 4000 cell values efficiently. my thought process includes Vlook ups and Hlookups but these do not seem like viable solution.

may be transpose each 1 X 80 records into single column and do a v lookup.. not sure. I am aware this is not a qlik question but any pointers would be helpful.

[swuehl · Accepted solution]

True, this is no Qlik related question, so please consider asking questions of this kind to a dedicated MS forum.

A simple google search should show a variety of possible solutions, though:

You can use tools (no complete list and no advertising intended):

http://stackoverflow.com/questions/114698/how-do-i-create-a-readable-diff-of-two-spreadsheets-using-...

GitHub - na-ka-na/ExcelCompare: Command line tool (and API) for diffing Excel Workbooks

or use excel standards:

https://blog.udemy.com/excel-diff/

3 Ways to Compare Data in Excel - wikiHow

Quickly compare two tables in excel 2007 | Get Digital Help - Microsoft Excel resource

Compare Two Excel Lists to Spot the Differences - YouTube

https://github.com/na-ka-na/ExcelCompare

[Anonymous]

Stephan thank you for your input. I will close this thread. If I come up with a qlik way of solving this I will post.

[swuehl]

If you want to compare these tables using QlikView, well, I remember a quite-old-but-still-good post by JohnW‌:

How to compare 2 tables and put non-matching results?