MicrosoftTrue, there is an element of risk. I have already been caught out with the 'faux' object oriented notation such as
arrayName.Rows.Count
which would capture the intent of ROWS(arrayName) but is no longer permitted within LET.
There must be some support for Unicode character sets otherwise you, along with Greeks or Egyptians would be saddled with English. It is the autocorrect functionality within Window that allows me to generate expressions such as
= ( (x₂-x)*y₁ + (x-x₁)*y₂ ) / (x₂-x₁)
with a degree of fluency. For stats
x̂ and x̅
have proved useful. Besides _1 and _2, I have also introduced \lambda to distinguish Lambda functions from named ranges or functions provided through add-ins.
= ArrayNameλ(3, 5)
versus
= INDEX(ArrayName, 3, 5)
or
= VSTACK(spc, A, B) [FastExcel]
versus
= VSTACKλ(A, B) [home made]
