'Using =Substitute Formula
I'm trying to use the formula =SUBSTITUTE to make a points sheet more convenient when calculating. I have two sets of points to calculate. One is for for points 1-10 and another is 1-25. For the 1-10 I can get the substitute formula to work for 5 numbers but after that they just exact cope the number that is in typed in. Here is the input and I'll also add a screenshot.
=(ARRAYFORMULA(VALUE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(G4:AM4,10,1),9,2),8,3),7,4),6,5),5,6),4,7),3,8),2,9),1,10))))
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|