ExcelBanter - Repeat values, deleting?

ExcelBanter (https://www.excelbanter.com/)

- Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)

- - Repeat values, deleting? (https://www.excelbanter.com/charts-charting-excel/24123-repeat-values-deleting.html)

SteW

Repeat values, deleting?

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?

John Mansfield

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.

----
Regards,
John Mansfield
http://www.pdbook.com

"SteW" wrote:

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?

All times are GMT +1. The time now is 05:17 PM.