I keep getting double false how to modify formula

formula: =(MID(SUMPRODUCT(--MID(B2,ROW(INDIRECT("1:" & LEN(B2))),1)) ,SEQUENCE(LEN(SUMPRODUCT(--MID(B2,ROW(INDIRECT("1:" & LEN(B2))),1)) )),1))=MID(SUMPRODUCT(--MID(B2,ROW(INDIRECT("1:" & LEN(B2))),...

excel

Formulas and Functions

Riny_van_Eekelen
May 29, 2022
imokayithinkso Since you are using a modern Excel version that allows you to use Dynamic Array functions, try this formula in C2 in stead

=TEXTJOIN(,,MID(B2,SEQUENCE(LEN(B2)),1))=TEXTJOIN(,,MID(B2,SEQUENCE(LEN(B2),,LEN(B2),-1),1))

Riny_van_Eekelen

Platinum Contributor

May 29, 2022

imokayithinkso Since you are using a modern Excel version that allows you to use Dynamic Array functions, try this formula in C2 in stead

=TEXTJOIN(,,MID(B2,SEQUENCE(LEN(B2)),1))=TEXTJOIN(,,MID(B2,SEQUENCE(LEN(B2),,LEN(B2),-1),1))

imokayithinkso
Copper Contributor
May 29, 2022
It worked thank you very much!

Forum Discussion

I keep getting double false how to modify formula

Resources