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