You can make your model a lot faster if you put both match formulas in a separate row and column respectively.
This is more efficient as you no longer recalculate the same MATCH for every row and for every column
Like in the attached example.
You can make your model a lot faster if you put both match formulas in a separate row and column respectively.
This is more efficient as you no longer recalculate the same MATCH for every row and for every column
Like in the attached example.
Posting Permissions
Reply With Quote