excel - Quickest formula method to create a list without duplicates -

i have list of entries using formula want clean duplicate values. efficient , quickest formula way that?

in rows have number+text (few letters)

my column like:

aa3 aa6 aa25 aa45 

i prefer extract use of 1 formula only

assuming entries in a1:a10, first go name manager (formulas tab) , define:

name: arry1

refers to: =row($a$1:$a$10)-min(row($a$1:$a$10))+1

then enter array formula**, used count expected number of returns, in b1:

=sum(if(frequency(match(a1:a10,a1:a10,0),arry1),1))

then enter array formula** in c1:

=if(rows($1:1)>b$1,"",index(a$1:a$10,small(if(frequency(match(a$1:a$10,a$1:a$10,0),arry1),arry1),rows($1:1))))

and copy down until start blanks.

**array formulas not entered in same way 'standard' formulas. instead of pressing enter, first hold down ctrl , shift, , press enter. if you've done correctly, you'll notice excel puts curly brackets {} around formula (though not attempt manually insert these yourself).