No. I'm assuming your original range containing blanks is stored as a Named Range called ARRAY. I wouldn't recommend that you use an entire column here though, i.e. A:A, since this can have negative effects upon calculation speed.
If this range is dynamic, i.e. may change in size, and you don't want to have to continually redefine it, then either use a fixed range which will be sufficiently large to cover all likelihoods, e.g. $A$1:$A$1000 (I would also recommend using absolute references - the "dollar signs" - here) or, even better, we can offset it so that it is dynamically and automatically redefined by Excel depending on how many entries are in that column, e.g. define ARRAY in Name Manager as:
=Sheet1!$A$1:INDEX(Sheet1!$A:$A,MATCH("zzz",Sheet1!$A:$A))
(Obviously amend the sheet name (Sheet1) and starting cell ($A$1) as required.)
ARRAY2 is another Named Range to be stored precisely as I gave it in my last post. You then paste the final formula I gave into the first cell in which you wish to start your list, making sure you commit it as an array formula, and then copy it down as far as required.
You'll get #N/As when there are no more unique returns to be given. If you would rather not have these, we can add an error trap to the formula to hide them:
=IFERROR(INDEX(ARRAY2,MATCH(TRUE,IF(FREQUENCY(MATCH(ARRAY2,ARRAY2,0),MATCH(ARRAY2,ARRAY2,0)),MMULT((--(ARRAY2>TRANSPOSE(ARRAY2))),ROW(INDIRECT("1:"&COUNTA(ARRAY2)))^0)=SMALL(IF(FREQUENCY(MATCH(ARRAY2,ARRAY2,0),MATCH(ARRAY2,ARRAY2,0)),MMULT((--(ARRAY2>TRANSPOSE(ARRAY2))),ROW(INDIRECT("1:"&COUNTA(ARRAY2)))^0)),ROWS($1:1))),0)),"")
Regards