How to dynamically deliminate a list with blanks cells?

[mdeanh5252]

Hello,
I have been searching and trying all sorts of dynamic array formulas that will eliminate out the blank cells from a list that populates based on user input, but haven't had a lot of luck.

I have currently this equation:
=IFERROR(INDEX(Section_List,MATCH(0,COUNTIF(C$635:C635,Section_List),0)),"")
With this Named Range Formula:
='Sheet1'!$B$636:INDEX('Sheet1'!$B$636:$B$655,MATCH(REPT("z",255),'Sheet1'!$B$636:$B$655))

Now this works to delimit out duplicates which i also have...

How might i modify this to remove blanks from the delimited list?

I have tried this equation that almost does it but the list comes out upside down?:
=IFERROR(LOOKUP(2,1/((COUNTIF($D$635:D635,$B$636:$B$655)=0)*($B$636:$B$655<>"")),$B$636:$B$655),"")

Anybody have a solution???

 

[Marcelo Branco]

See if this works

=IFERROR(INDEX(Section_List,MATCH(0,(Section_List="")+COUNTIF(C$635:C635,Section_List),0)),"")
Ctrl+Shift+Enter

M.

 

[mdeanh5252]

That worked perfectly!

Thank You!