Check if the cells are not blank

I have attempted to alter this example to simply check if the cells are not blank by replacing the "X" with "<>", but I get errors in the SMALL function--it looks like the IF statement is just returning an array with all of the values set to FALSE, and none of the values in the array call out a location of the next filled cell.

How could you alter your fixed XLSX file to check for non-blank cells instead of "X" specifically?

Thanks,

Micah

mkgoff11,

Welcome to the forum!
Assuming the items you want to return are in column A and the column you're checking for non-blanks is also column A, put this array formula in cell B1 and copy down:

IFERROR(INDEX($A$1:$A$10,SMALL(IF($A$1:$A$10<>"",ROW($A$1:$A$10)),ROW(A1)),"")

Note that array formulas must be entered with Ctrl+Shift+Enter and not just Enter.