Bert2005

<div>
Having said that, as soon as you select Remove Duplicates it will do just that and there is no reversing the step. &nbsp;I normally copy the data (in your example Column A) and paste into another column then remove the duplicates. &nbsp;That way I have both the original list and the reduced-down list where duplicates have been removed.
</div>

<div>
If by first column you mean column A, you can run this macro: <pre><code class="code-10 nolinks" id="code-20-43057692-1">Sub RemoveNSort()
Dim lRow As Double

lRow = Cells(Rows.Count, 1).End(xlUp).Row
Columns("A:A").Select
&nbsp; &nbsp;ActiveSheet.Range("$A$1:$A$" &amp; lRow).RemoveDuplicates Columns:=1, Header:=xlNo
&nbsp; &nbsp; ActiveWorkbook.Worksheets("Sheet1").Sort.SortFields.Clear
&nbsp; &nbsp; ActiveWorkbook.Worksheets("Sheet1").Sort.SortFields.Add2 Key:=Range("A1"), _
&nbsp; &nbsp; &nbsp; &nbsp; SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:=xlSortNormal
&nbsp; &nbsp; With ActiveWorkbook.Worksheets("Sheet1").Sort
&nbsp; &nbsp; &nbsp; &nbsp; .SetRange Range("A1:A" &amp; lRow)
&nbsp; &nbsp; &nbsp; &nbsp; .Header = xlNo
&nbsp; &nbsp; &nbsp; &nbsp; .MatchCase = False
&nbsp; &nbsp; &nbsp; &nbsp; .Orientation = xlTopToBottom
&nbsp; &nbsp; &nbsp; &nbsp; .SortMethod = xlPinYin
&nbsp; &nbsp; &nbsp; &nbsp; .Apply
&nbsp; &nbsp; End With
Range("A1").Select
End Sub
</code></pre>Paul
</div>

<div>
I meant the copying. 
 
How do I do the sort column for numbers instead of letters. 
 
Oh I got it. Under Data &gt;&gt;&nbsp;Sort &gt;&gt;&nbsp;then use numbers.
</div>

<div>
<div class="content wysiwyg-content">
Excel 2019. How do I put in the first column a list of three digit numbers like: 
 
256 
745 
989 
284 
103 
256 
 
Note the first and last are the same. 
 
I want to after putting in 100 numbers or so, be able to make Excel a) delete any duplicates and b) list the numbers in column A from lowest number to highest number.
</div>
</div>

Excel 2019. How do I put in the first column a list of three digit numbers like:

256
745
989
284
103
256

Note the first and last are the same.

I want to after putting in 100 numbers or so, be able to make Excel a) delete any duplicates and b) list the numbers in column A from lowest number to highest number.

Need help organizing the first column of an Excel sheet

Excel Table

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.