With cell V1 empty, enter the following formula in V2 and copy down
until you get #N/A:

=INDEX(A1:$A$7,MATCH(0,COUNTIF($V$1:V1,A1:$A$7),0) )

....confirmed with CONTROL+SHIFT+ENTER, not just ENTER.

Hope this helps!

In article ,
"Kevin Lin" wrote:

Thanks Dave for your help.

But is there a way that you could input a formula instead
of having the advanced filter?

Thank you,
Kevin