Solved

Sort serverlist in excel

Posted on 2013-01-31
7
170 Views
Last Modified: 2013-02-15
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
Comment
Question by:janhoedt
  • 3
  • 2
7 Comments
 
LVL 92

Expert Comment

by:Patrick Matthews
ID: 38839244
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
 

Author Comment

by:janhoedt
ID: 38839429
Thanks. Servernames have sometimes 3 digits, f.e. server01, server100. Please advise on that.
0
 

Author Comment

by:janhoedt
ID: 38839470
And also please advise howto seperate within excel.
0
What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

 
LVL 7

Accepted Solution

by:
karunamoorthy earned 500 total points
ID: 38839669
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
 
LVL 7

Expert Comment

by:karunamoorthy
ID: 38848223
Pl post you comments here for further assistance!
0
 

Author Comment

by:janhoedt
ID: 38848552
No, sorry, don't get it.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

What is a Form List Box? (skip if you know this) The forms List Box is the alternative to the ActiveX list box. If you are using excel 2007, you first make sure you have a developer tab (click the Orb)->"Excel Options"->Popular->"Show Developer tab…
Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvie…
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now