What does this mean? Is it Excel 2016 or Office365?Excel 2016 e 365
I think it is 'and'; just a minor shift of language?What does this mean? Is it Excel 2016 or Office365?
= LET(
count, 1+end-start,
close, SCAN(0,count, LAMBDA(t,x,t+x)),
open, 1 + close - count,
k, SEQUENCE(MAX(close)),
row, XMATCH(k,open,-1),
instance, k+1-INDEX(open,row),
baseCode, INDEX(Code,row),
modifier, TEXT(INDEX(start,row)+instance-1,"0000"),
VALUE(baseCode & modifier)
)
Nice! Mind you, 'each List.Transform(([start]..[End])' is not quite as straightforward for me as it obviously is for you.A straightforward Power Query solution in cell G1 which should work in both those versions of Excel.
You don't really need ARRAYTOTEXT - I was just exploring some of these newish functions.My version doesn't have this ARRAYTOTEXT function Using the site https://en.excel-translator.de/translator/ , translating from English to Portuguese (Brazil) doesn't have this translation either
I updated it but it didn't help, this formula didn't work.
Could you post the model with this formula so that I can see if it will automatically translate
Reimplemented from my earlier post!I need you to post in the model because translating didn't work