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