<div>
In Excel 2007+, you can use /Data/Remove Duplicates to get a distinct list. &nbsp;In Excel 2003, use the Advanced Filter.<br />
<br />
For the sorting, if the naming convention is <b><i>ALWAYS</i></b> &quot;Server##&quot;, with a two digit number at the end, then use formulas to separate the parts:<br />
<br />
=LEFT(A2,LEN(A2)-2) &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;--- this is the base server name<br />
=VALUE(RIGHT(A2,2)) &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;--- this is the server number<br />
<br />
Then sort your list based on those new columns.<br />
<br />
If that naming convention is not always followed, then you need to be more specific about your requirements.
</div>


In Excel 2007+, you can use /Data/Remove Duplicates to get a distinct list.  In Excel 2003, use the Advanced Filter.

For the sorting, if the naming convention is ALWAYS "Server##", with a two digit number at the end, then use formulas to separate the parts:

=LEFT(A2,LEN(A2)-2)                   <--- this is the base server name
=VALUE(RIGHT(A2,2))                 <--- this is the server number

Then sort your list based on those new columns.

If that naming convention is not always followed, then you need to be more specific about your requirements.

<div>
Thanks. Servernames have sometimes 3 digits, f.e. server01, server100. Please advise on that.
</div>


Thanks. Servernames have sometimes 3 digits, f.e. server01, server100. Please advise on that.

<div>
And also please advise howto seperate within excel.
</div>


And also please advise howto seperate within excel.

<div>
Pl post you comments here for further assistance!
</div>


Pl post you comments here for further assistance!

<div>
<div class="content wysiwyg-content">
Please advise howto sort a serverlist in excel, f.e. Server01, server02, ... server11 ....<br />
Now it sorts server01, server11...<br />
Then duplicates should also be removed.<br />
<br />
Thanks.<br />
J
</div>
</div>


Please advise howto sort a serverlist in excel, f.e. Server01, server02, ... server11 ....
Now it sorts server01, server11...
Then duplicates should also be removed.

Thanks.
J

Sort serverlist in excel

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