Oct 08 2021 03:39 AM
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.
Oct 08 2021 04:15 AM
=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.
Oct 08 2021 04:47 AM
Oct 08 2021 05:09 AM
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.
Oct 08 2021 05:14 AM
Feb 10 2023 07:32 PM - edited Feb 10 2023 07:32 PM