Quote:
Originally Posted by Jon Stratis
Ok, second try now that I had a few more free minutes...
Again, using the vlookup function to transition from number of assists to points. Here though, I'm simply doing a counta on each possible combination for 3 assists. By default, that also includes all possible combinations of 2 and 1 assists. By doing a max, we find the maximum possible assists that were counted.
|
Tangentially related. Index(match()) is much more efficient than vlookup, and a more robust way to link in case people insert collumns, etc... I find it more intuitive to setup as well.
The performance is far better. Not a huge issue for most excels, but a huge performance difference in google spreadsheets.