unique distinct list from a column but

The formulae that I gave you in message # 7 will not leave blanks between values and will only return values that have a value in the next column.
Here is the formula with the correct cell references for your current workbook. This doesn't require Array Entry as previously stated. Enter normally.

Formula:

=IFERROR(INDEX($A$8:$A$14,MATCH(1,INDEX((COUNTIF($D$7:D7,$A$8:$A$14)=0)*($A$8:$A$14<>"")*($B$8:$B$14<>""),0),0)),"")

If you don't want to use the criteria in column B then the formula would be as follows to return the unique values from column A.

Formula:

=IFERROR(INDEX($A$8:$A$14,MATCH(1,INDEX((COUNTIF($D$7:D7,$A$8:$A$14)=0)*($A$8:$A$14<>""),0),0)),"")

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.