Sorting of Data

G

Guest

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
 
G

Guest

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.
 
A

Ardus Petus

Data>Filter>Advanced Filter can produce results in another sheet!

Otherwise, you'll need a VBA macro.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top