Indexing of Name

Hello guys,
I have column like this in my spread sheet.

Name
a
c
b
a
c
a
b
c
d
a
c
b

I want to do indexing(output) of that column as below mentioned
format(without duplication of any data of column 'name') using advance
function of excel.

Name
a
b
c
d

regards,

Use Data>Filter>Advanced Filter
Check 'Copy to another location' , then click in the 'Copy to' box and
indicate where you want the data. Finally, check 'Unique records only' and
click on OK


"Charlie" wrote:

> Hello guys,
> I have column like this in my spread sheet.
>
> Name
> a
> c
> b
> a
> c
> a
> b
> c
> d
> a
> c
> b
>
> I want to do indexing(output) of that column as below mentioned
> format(without duplication of any data of column 'name') using advance
> function of excel.
>
> Name
> a
> b
> c
> d
>
> regards,
>
>