Hi There, I am using the function IF INDEX and MATCH to calculate a sum. The formula goes like this
The issue I have is I use this formula accross many columns which make the formula gigantic resulting to slow down my excel sheet. The code is as followPlease Login or Register to view this content.
My question is, is there a way to siplify this code to make it more efficient?Please Login or Register to view this content.
Bookmarks