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.