Extract a list from a column - excluding blanks

Hello Forum,

Please can you help me with a formula to extract a list from BR29:BR218 in attached doc - excluding blanks.

The first formula should be in cell CD 29.

Formulas should continue down to CD218, but should be blank when there is no data (iferror?).

I'd prefer a non-array formula (someone else will be maintaining the file) unless there is no other option than array.

Any help would be very much appreciated!

Try

=IFERROR(INDEX($BR$29:$BR$300,SMALL(IF(ISNUMBER($BR$29:$BR$300),ROW($BR$29:$BR$300)-ROW($BR$29)+1,""),ROWS($B$29:B29))),"")

Enter with Ctrl+Shift+Enter

Once entered down to final row no other intervention is required.

John, thank you for your super quick response - that works excellently, thank you

I won't mark this resolve just in case I can get a non-array formula.

Huge thanks, John!

Thank you for the rep.

You now have your non-array formula from Silva: I must try and remember how to do this as it is a fairly common request.

Yes, John, it's perfect.

Silva, thank you so much!!

What an incredible, wonderful forum this is