Indexing of Name

C

Charlie

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,
 
D

Duke Carey

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
 
Top