Forum Discussion
Duplicate Formula with Multiple Data Cells
Hi, I'm looking to use a formula to transfer information from several columns to another table. The problem i'm having is i'm trying to transfer multiple rows with the same value. I.e. I want eac...
Hi,
To copy rows, on data sample like this,
in F2 you may use
=IFERROR(OFFSET($A$1,AGGREGATE(15,6,1/($A$2:$A$20="yes")*(ROW($B$2:$B$20)-ROW($A$1)),ROW()-ROW($F$1)),1),"")
and drag it down, same for other columns.
Similar with your model.