johnny51981
Active Member
- Joined
- Jun 8, 2015
- Messages
- 366
I am in the midst of rebuilding all of my teams reports/processes that are done through Excel Power Query workbooks, macros and such.
In order to call it complete, there must be a validation done to make sure that, while the steps in Power Query are different, the results are the same in the new one as they would be in the old version.
The issue being, the number of sheets in the workbooks and the number of rows/columns in each of those sheets.
I could totally line up the sorts and just do an easy match formula, however...I think my computer will crap out on the number of calculations being done.
Any ideas would be greatly appreciated!
In order to call it complete, there must be a validation done to make sure that, while the steps in Power Query are different, the results are the same in the new one as they would be in the old version.
The issue being, the number of sheets in the workbooks and the number of rows/columns in each of those sheets.
I could totally line up the sorts and just do an easy match formula, however...I think my computer will crap out on the number of calculations being done.
Any ideas would be greatly appreciated!