Sorting of Data
 

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

Sorting of Data
 

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

Sorting of Data
 

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

Sorting of Data
 

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