Forum Discussion
Werner_Geiger
Sep 23, 2021Brass Contributor
How to assign and reuse a temporary name within a formula?
If you have a complex formula, e.g. (Sorry for German language. Should be understandable anyway😞 =WENN(ISTZAHL(
VERGLEICH(FALSCH;BEREICH.VERSCHIEBEN(daten;1;0;ZEILEN(daten)-1)>=daten;0));
"D...
- Sep 23, 2021Yes it is! Have a look at the LET function (does require Office 365 though): https://support.microsoft.com/en-us/office/let-function-34842dd8-b92b-4d3f-b325-b8b8f9908999
JKPieterse
Sep 23, 2021Silver Contributor
Yes it is! Have a look at the LET function (does require Office 365 though): https://support.microsoft.com/en-us/office/let-function-34842dd8-b92b-4d3f-b325-b8b8f9908999
Werner_Geiger
Sep 23, 2021Brass Contributor
JKPieterse
Great, thanks a lot! This does the job:
=LET(tmp; VERGLEICH(FALSCH;BEREICH.VERSCHIEBEN(daten;1;0;ZEILEN(daten)-1)>=daten;0);
WENN(ISTZAHL(tmp);"Datum nicht sortiert! Z(" & tmp+1+HeadRow & ")";""))
I think I read about this (new) LET before but forgot about it.