Hi all,
I have got column like mentioned below.
Name
a
c
d
f
a
b
c
t
b

I want to sort out data like
Name
a
b
c
d
f
t
Help me to get sorted data(avoid duplication) in this way using advace
function of MS Excel.

Thanks

You can use DataSort, then DataFilterAdvanced Filter (no dupes)

HTH
--
AP

"Charlie" a écrit dans le message de
news: ...
Hi all,
I have got column like mentioned below.
Name
a
c
d
f
a
b
c
t
b

I want to sort out data like
Name
a
b
c
d
f
t
Help me to get sorted data(avoid duplication) in this way using advace
function of MS Excel.

Thanks

Thanks for sending reply.
I know we can use sort or filter option.but i want to use advance function
of excel to get desired result in other sheet.

help me.

"Ardus Petus" wrote:

You can use DataSort, then DataFilterAdvanced Filter (no dupes)

HTH
--
AP

"Charlie" a écrit dans le message de
news: ...
Hi all,
I have got column like mentioned below.
Name
a
c
d
f
a
b
c
t
b

I want to sort out data like
Name
a
b
c
d
f
t
Help me to get sorted data(avoid duplication) in this way using advace
function of MS Excel.

Thanks

DataFilterAdvanced Filter can produce results in another sheet!

Otherwise, you'll need a VBA macro.
--
AP

"Charlie" a écrit dans le message de
news: ...
Thanks for sending reply.
I know we can use sort or filter option.but i want to use advance function
of excel to get desired result in other sheet.

help me.

"Ardus Petus" wrote:

You can use DataSort, then DataFilterAdvanced Filter (no dupes)

HTH
--
AP

"Charlie" a écrit dans le message de
news: ...
Hi all,
I have got column like mentioned below.
Name
a
c
d
f
a
b
c
t
b

I want to sort out data like
Name
a
b
c
d
f
t
Help me to get sorted data(avoid duplication) in this way using advace
function of MS Excel.

Thanks