Forum Discussion
tobiasmohlin
Oct 02, 2024Copper Contributor
The text my functions return doesn't spill over to adjacent cells on the new worksheet.
Hello everyone! I'm a bit new to excel, but despite that i've tried my hands at what i consider a "difficult" challange. I'd like to have two sheets, one that contains all the information, and a...
tobiasmohlin
Oct 02, 2024Copper Contributor
=IFERROR(INDEX(Databas!A2:H40,SMALL(IF(Databas!I2:I40=TRUE,ROW(Databas!I2:I40)-ROW(Databas!I2)+1),ROWS(Databas!I2:I2)),0),"")
The code above is what i'm using to pick up the information from the other sheet.
For every new row i add an additional row in the last part of the function. so instead of I2:I2 it's now I2:I3, then I2:I4 and thus forth. See below for an example of how the second row would've looked
=IFERROR(INDEX(Databas!A2:H40,SMALL(IF(Databas!I2:I40=TRUE,ROW(Databas!I2:I40)-ROW(Databas!I2)+1),ROWS(Databas!I2:I3)),0),"")
The code above is what i'm using to pick up the information from the other sheet.
For every new row i add an additional row in the last part of the function. so instead of I2:I2 it's now I2:I3, then I2:I4 and thus forth. See below for an example of how the second row would've looked
=IFERROR(INDEX(Databas!A2:H40,SMALL(IF(Databas!I2:I40=TRUE,ROW(Databas!I2:I40)-ROW(Databas!I2)+1),ROWS(Databas!I2:I3)),0),"")