G Guest Apr 29, 2005 #1 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?
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 Apr 29, 2005 #2 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.
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.
