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.
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.
Excel Formula:
=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))),"")