Repeat values, deleting?

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?
 
G

Guest

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.
 

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
Repeat Values in rows 4
Lesser value from list of values? Lowest, Least? 3
what excel function to use 2
Query in excel 2

Top