Forum Discussion
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...
=MAKEARRAY(ROWS(A2:G9),COLUMNS(A2:G9),LAMBDA(r,c,IF(INDEX(A2:G9,r,c)=1,INDEX(A1:G1,,c),"")))An alternative with Office 365 or Excel for the web could be this formula.