Forum Discussion
anupambit1797
Sep 11, 2023Iron Contributor
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...
anupambit1797
Iron Contributor
OliverScheurich
Sep 12, 2023Gold Contributor
=IF(A2=1,A$1,"")
This formula could be a very simple alternative. The formula is in cell O2 and filled across range O2:AB17817.