• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 229
  • Last Modified:

Sort serverlist in excel

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
0
janhoedt
Asked:
janhoedt
  • 3
  • 2
1 Solution
 
Patrick MatthewsCommented:
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.
0
 
janhoedtAuthor Commented:
Thanks. Servernames have sometimes 3 digits, f.e. server01, server100. Please advise on that.
0
 
janhoedtAuthor Commented:
And also please advise howto seperate within excel.
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
karunamoorthyCommented:
separate server10 as server + 10 and server100 as server+100, use like this

suppose a1 cell contains server10 then in A2 cell write
=mid(a1,7,10) you will get 10
a2 cell contains server100 then you will get 100
Hope you got it.
0
 
karunamoorthyCommented:
Pl post you comments here for further assistance!
0
 
janhoedtAuthor Commented:
No, sorry, don't get it.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now