Formula: consolidating a list with blank cell values NOT true blank cells

I have the following formula:


=INDEX($BL$2:$BL$51, SMALL(IF(ISBLANK($BL$2:$BL$51), "", ROW($BL$2:$BL$51)-MIN(ROW($BL$2:$BL$51))+1), ROW($A1)))


which searches through an array and consolidates a list removing any blanks.


The problem is the array it's searching through is itself pulling information from other formula based lists.


Therefore the cell reference is not always a true blank cell - rather just a cell with a blank value and a formula accociated to it.


How do I adjust the above formula so it recognises a blank value NOT a blank cell?


Thanks

Try changing . . . IF(ISBLANK($BL$2:$BL$51), "", . . . to . . . IF($BL$2:$BL$51="", "", . . .

It can also be turned into a non-array formula (ENTER only) by using:

=INDEX($BL:$BL,AGGREGATE(15,6,ROW($BL$2:$BL$51)/($BL$2:$BL$51=""), ROWS(A$3:A3)))

where the bit in RED refers to the cell that the formula STARTS in (beofre copying down)

@AndyT88: You're welcome.