Formula Beautifier (expand / indent)

Hi everyone,

I've created a utility for the site that might please some of you

It's a tool that indents and expands an Excel (or Google Sheets) formula over multiple lines and can help you better understand long formulas in some cases

Example 1

Before:

=INDIRECT(ADDRESS(9,MAX(IF(OR($AE13=$R13,$AL13=$R13,$AP13=$R13,$AT13=$R13,$BO13=$R13,$BV13=$R13,$CC13=$R13,$CG13=$R13),COLUMN($AE13:$HA13)))+16))

After:

=INDIRECT(
    ADDRESS(
        9,
        MAX(
            IF(
                OR(
                    $AE13=$R13,
                    $AL13=$R13,
                    $AP13=$R13,
                    $AT13=$R13,
                    $BO13=$R13,
                    $BV13=$R13,
                    $CC13=$R13,
                    $CG13=$R13
                ),
                COLUMN(
                    $AE13:$HA13
                )
            )
        )+16
    )
)

Example 2

Before:

=LET(range,A2:A59,MAP(range,SEQUENCE(ROWS(range)),LAMBDA(test,i,COUNTIF(ARRAY_CONSTRAIN(range,i,1),test))))

After:

=LET(
    range,
    A2:A59,
    MAP(
        range,
        SEQUENCE(
            ROWS(
                range
            )
        ),
        LAMBDA(
            test,
            i,
            COUNTIF(
                ARRAY_CONSTRAIN(
                    range,
                    i,
                    1
                ),
                test
            )
        )
    )
)

About

The tool has no depth limit (you can put a formula with 100 nested levels if you wish) and it automatically detects the separator (; or ,).

The tool is here: https://www.excel-pratique.com/en/tools/formula-beautifier

As a reminder, if one day you forget where to find it, there is a Tools link at the bottom of every page of the site and the forum