Make a Dynamic List & Ignore Blank Cells

[daxcallagher]

Hi Guys
Having some trouble making a dynamic list without blank cells.

I have made a quick 20 second YouTube video of my request
https://youtu.be/bL2LR5FlCJ8

I cant upload my excel workbook for some reason even when using the manage attachments, just says upload failed so other than the video I cant offer much else to help you guys out.

any help greatly appreciated.

[Sam Capricci]

so, assuming your list begins in A2 and goes down from there, I've had luck with this formula which will create a distinct list and omit blanks...
=IFERROR(INDEX($A$2:$A$15,MATCH(0,INDEX(COUNTIF(B$1:B1,$A$2:$A$15&""),),0))&"","")
the section COUNTIF(B$1:B1 needs to begin one row above the data