Make a list removing those containing "Blank"

[londa_vba]

Hi
I found the code below that works how I would like; however, when I have some merged cells between rows 34 through 38 and would like the list to continue on the next page at row 39-64 and I am not sure how to make that happen.

=IFERROR(INDEX($V$10:$V$33,SMALL(IF(NOT($V$10:$V$33="Blank"),ROW($V$10:$V$33)-ROW(INDEX($A$10:$A$33,1,1))+1),ROWS($Y$10:$Y10))),"")

 

[londa_vba]

Hi
I found the code below that works how I would like; however, when I have some merged cells between rows 34 through 38 and would like the list to continue on the next page at row 39-64 and I am not sure how to make that happen.

=IFERROR(INDEX($V$10:$V$33,SMALL(IF(NOT($V$10:$V$33="Blank"),ROW($V$10:$V$33)-ROW(INDEX($A$10:$A$33,1,1))+1),ROWS($Y$10:$Y10))),"")

Disregard this post. Not sure how to delete it