Forum Discussion
VBA - Populate columns automatically from complex formulas
Hello there, I'm fighting with the file attached, and I don't manage to find an efficient solution. The file is composed by anonymized account numbers in Column A, other parameters in the followin...
Shorter formulas:
F2:
=IF(AND(ISNUMBER(SEARCH({"'T1:","'T2:"},D2))),"Tiered","Not tiered")
or
=IF(AND(ISNUMBER(SEARCH("'T"&SEQUENCE(2)&":",D2))),"Tiered","Not tiered")
G2:
=SUM(--ISNUMBER(SEARCH("'T"&{1,2,3,4,5}&":",D2)))
or
=SUM(--ISNUMBER(SEARCH("'T"&SEQUENCE(5)&":",D2)))
The formula in N2 is far too complicated for me to understand. Is there some kind of logic behind it?