Forum Discussion
Excel 365 LET Function not recognized
Most probably you are on semi-annual channel, if so update on Current one.
Most probably you are on semi-annual channel, if so update on Current one.
Does this also apply to Microsoft Office Professional Plus 2021?
Because I cannot get the LET command to work; however, it works on my company laptop that has Microsoft Office 365 Pro Plus.
Does the LET function just not work on Microsoft Office Professional Plus 2021!? 😲
It shall be available for 2021 LET function - Microsoft Support
Under "not work" what exactly do you mean - you can't find it among other functions (on ribbon Formulas->Logical->LET), or you have some kind of error using it; or something else.
If you check File->Account what is exact version of your Excel?
SergeiBaklan - I replied to your message above.
My version of Excel is this: Version 2408 (Build 17928.20156 Click-to-Run)
The LET formula I'm using is this:=LET(z,A2:A9,SORTBY(z,MID(z,1+(LEFT(z,2)="A ")*2+(LEFT(z,3)="An ")*3+(LEFT(z,4)="The ")*4,99)))It's to sort a Movie List without using the articles "A," "An," and "The."
This works great on my work laptop with Office 365, but not my Office 2021 at home.
It gives me the error "The first argument of LET must be a valid name" even though I'm doing it exactly the same on both! (I only expanded the first column on the second image to show that it the formula is indeed working properly and sorting the list names alphabetically in the second column.)
https://imgur.com/PBskQVB
https://imgur.com/djRDbsj