Repeat values, deleting?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

If I have a list like 1,2,1,5,3,4,3,5 can I get excel to sort it and delete
repeat values, giving 1,2,3,4,5?
 
Stew,

In Excel's online help, look up the "Auto" and "Advanced" filtering
techniques. To see the options, go to the Standard Toolbar and select Data
-> Filter.
 
You must log in or register to reply here.

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

Similar Threads

Access Macro Repeat Expression using value of a field in table 0
x-values revert to item number 6
scatter graph repeated coordinate 1
Excel EXCEL HELP! Need to copy cell into the same worksheet name 7
what excel function to use 2
How to get tweets in chronological order? 2
Outlook IMAP 0
LOOKUP problem with non-sorted vector 3

Back
Top