F9 Evaluation KEY to be available inside LET Functions throughout Excel, PQ, BI (That is Missing)!

%3CLINGO-SUB%20id%3D%22lingo-sub-2826454%22%20slang%3D%22en-US%22%3EF9%20Evaluation%20KEY%20to%20be%20available%20inside%20LET%20Functions%20throughout%20Excel%2C%20PQ%2C%20BI%20(That%20is%20Missing)!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2826454%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EI%20couldn't%20see%20any%20benefit%20of%20using%20LET%20function%2C%20because%20F9%20Evaluation%20key%20is%20not%20working%20inside%20LET%2C%20and%20that%20makes%20it%20very%20difficult%20to%20use%20it.%20I%20request%20Microsoft%20team%20to%20add%20F9%20key%20throughout%20its%20product%2C%20whether%20PQ%2C%20BI%20or%20any%20function%2C%20F9%20evaluation%20key%20must%20work%2C%20NAME%20Error%20pop%20in%20when%20pressing%20F9%20key.%20I%20even%20sent%20the%20screenshots%20through%20Excel%20365%20feedback%2Fsuggestion%2C%20but%20no%20response.%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EScreenshot%20attached.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2826454%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2826571%22%20slang%3D%22en-US%22%3ERe%3A%20F9%20Evaluation%20KEY%20to%20be%20available%20inside%20LET%20Functions%20throughout%20Excel%2C%20PQ%2C%20BI%20(That%20is%20Missing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2826571%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1015056%22%20target%3D%22_blank%22%3E%40Al-Ahdal%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E%3DLET(u%2CUNIQUE(B4%3AB18)%2Cu)%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EThis%20is%20the%20syntax%20you%20have%20to%20use%20in%20order%20to%20calculate%20the%20result%20of%20a%20name%20(name1%20equals%20u%20in%20this%20example).%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3ESyntax%20of%20let%20function%20is%3A%26nbsp%3B%20%26nbsp%3B%20%3DLET(name1%2Cname1_value%2Ccalculation_or_name2.......)%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%22%26nbsp%3B%20%26nbsp%3Bcalculation_or_name2%26nbsp%3B%20%22%26nbsp%3B%20allows%20the%20calculation%20of%20the%20result%20of%20u%20(%3Dname1)%20in%20this%20example.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2826707%22%20slang%3D%22en-US%22%3ERe%3A%20F9%20Evaluation%20KEY%20to%20be%20available%20inside%20LET%20Functions%20throughout%20Excel%2C%20PQ%2C%20BI%20(That%20is%20Missing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2826707%22%20slang%3D%22en-US%22%3EThe%20formula%20which%20I%20mentioned%20in%20pdf%20is%20absolutely%20correct.%20The%20issue%20is%2C%20inside%20the%20LET%20function%2C%20we%20cannot%20able%20to%20evaluate%20via%20F9%20key.%20And%20this%20is%20the%20real%20issue%20in%20the%20newly%20LET%20formula%2C%20F9%20evaluation%20key%20must%20work%20throughout%20excel%20platform.%3C%2FLINGO-BODY%3E
Occasional Contributor

I couldn't see any benefit of using LET function, because F9 Evaluation key is not working inside LET, and that makes it very difficult to use it. I request Microsoft team to add F9 key throughout its product, whether PQ, BI or any function, F9 evaluation key must work, NAME Error pop in when pressing F9 key. I even sent the screenshots through Excel 365 feedback/suggestion, but no response.

 

Screenshot attached.

4 Replies

@Al-Ahdal 

=LET(u,UNIQUE(B4:B18),u)

This is the syntax you have to use in order to calculate the result of a name (name1 equals u in this example).

Syntax of let function is:    =LET(name1,name1_value,calculation_or_name2.......)

"   calculation_or_name2  "  allows the calculation of the result of u (=name1) in this example.

 

The formula which I mentioned in pdf is absolutely correct. The issue is, inside the LET function, we cannot able to evaluate via F9 key. And this is the real issue in the newly LET formula, F9 evaluation key must work throughout excel platform.

@Al-Ahdal 

Afraid that will be fundamental change. That's like if you write any code, e.g. on VBA, select any string within it and would like to see what it returns pressing F9.

F9 evaluation key is available in Excel, but unfortunately inside newly build LET function, it is completely ignored. MS should look into it. Moreover, this F9 evaluation key must be made available across Excel platforms whether PQ, BI etc.