Formula to Skip row and move to the next if criteria is not met

Hello all,

Not sure how to word this appropriately.

I am trying to fill in consecutive rows with data from another sheet that has a column with an X in it to mark its more important. How can I do this so if the first row does not have the "x", it will move to the next row. Then once the next one is found, move on to the next row without copying the data already marked in the first row.

I was going to try to use vba, but this sheet will also be used on google sheets. Which to my understanding, that code will not work on googlesheets.

Data Sheet
Row
1
2x
3x
4
5x

new sheet
Row
1,2x
2,3x
3,5x

You could use a helper column (C) in the first sheet with this formula in C2:

=IF(B2="x",MAX(C$1:C1)+1,"-")

copy this down as far as you like.

Then in the second sheet you could have this formula in A2:

=IFERROR(INDEX(Sheet1!A:A,MATCH(ROWS($1:1),Sheet1!$C:$C,0)),"")

which you can copy into B2, and then copy those two formulae down until you get blanks.

The attached file illustrates.

Hope this helps.

Pete

Hey Pete,


Sorry for the delay on getting back. That Did Work. I appreciate your help!

You're welcome - glad to help.

Pete