Forum Discussion

anupambit1797's avatar
anupambit1797
Iron Contributor
Sep 11, 2023

IF FORMULA

Dear Experts,                   Need your help , So , in a column if I have "1" then print the 1st row of that column, if "0" print nothing, could you please share how to achieve this? also apart fr...
excel
Formulas and Functions
Patrick2788's avatar
Patrick2788
Silver Contributor
Sep 11, 2023

anupambit1797 

This will do it:

 

=LET(
    cols, COLUMNS(header),
    matrix, (rgb = 1) * SEQUENCE(, cols),
    print_header, LAMBDA(element,
        IF(element > 0, INDEX(header, , element), "")
    ),
    MAP(matrix, print_header)
)

 

Resources