4 ms·
so true - I held on to Excel 2003 until 2018 at which point it really just didn't work anymore on Win10 As someone various colleagues have urged to compete at
by emeril 2y ago
so true - I held on to Excel 2003 until 2018 at which point it really just didn't work anymore on Win10
As someone various colleagues have urged to compete at modeloff years ago, it's really just something one would do if they enjoy it, anyone smart/experienced enough to do modeloff/etc. would also know it's not a good value proposition in terms of winnings/expected value/etc.
Also, anyone who writes a formula like "=SUM(CODE(MID(LOWER(SUBSTITUTE(SUBSTITUTE(C3,”:”,””)" is a bit suspect imo
from chatgpt:
Here's a practical example to illustrate:
Assume cell C3 contains the string "A:B:c".
Removing colons results in "ABc".
Converting to lowercase results in "abc".
Extracting ASCII codes of "a", "b", and "c" gives 97, 98, and 99, respectively.
Summing these values gives 97 + 98 + 99 = 294.
So, the formula SUM(CODE(MID(LOWER(SUBSTITUTE(SUBSTITUTE(C3,”:”,””)))))) for the string "A:B:c" results in 294.
- konstantinua00 2y agowhat does MID do?
- deleted 2y ago[deleted]
- jazzyjackson 2y agonot a damn thing in the truncated formula expressed in the article, but in real life it is substring(text, start index, length)
- eps 2y ago> SUM(CODE(MID(LOWER(SUBSTITUTE(SUBSTITUTE(C3,”:”,””) Smells like K, except way more human-friendly :)
- TeMPOraL 2y agoMake that code lowercase, introduce significant whitespace and call the langauge "Boa" or something, and it's guaranteed it'll take the world of scientific computing by storm.