Excel 365 LET Function not recognized

[AndresCMC]

Hi,

I just upgraded to Office 365 ProPlus

The LET function is not available.

Does anybody know how to fix this issue?

\Thank you

[#2 · Accepted solution]

@AndresCMC 

Most probably you are on semi-annual channel, if so update on Current one.

[#3]

@SergeiBaklan  You're the man!

Thank you!

[#4]

@AndresCMC , you are welcome

[#5]

@SergeiBaklan If on a semi-annual enterprise channel then likely I cannot switch  or update on the current one ?
Is there any other way to get this feature ?  It would be extremely helpful with my work but it would be near impossible to have our admins change anything in this space.

Thanks in advance.  
Gav

[#6]

@GavCol_icr 

How to change the channel is here https://docs.microsoft.com/en-us/deployoffice/change-update-channels That's only IT administrator could change it; or you may change yourself if you have administrative rights on your machine and that's not against your organization policy.

And there are 3 versions of semi-annual enterprise (1908, 2002 and 2008, latest is exists with preview). Not if LET() is on some of it, you may check release notes here https://docs.microsoft.com/en-us/officeupdates/semi-annual-enterprise-channel

[#7]

@SergeiBaklan 

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!? 😲

[#8]

@WillieW 

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?

[#9]

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.)

MS Office Pro Plus 2021 

MS Office Pro Plus 365 

[#10]

@SergeiBaklan - I replied to your message above.