Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. DannyTEM

    IP range manipulation in Excel?

    Hi Yogi, Thanks for stopping buy. The reason those results differ is because the first range, should start at 145.45.67 and should stop at 145.45.71 because the following does not exist: 145.45.72 145.45.73 145.45.74 The results of your data include these in the data. Can I ask how you got...
  2. DannyTEM

    IP range manipulation in Excel?

    81 132 253 81 132 254 81 132 255 81 151 8 81 151 9 81 151 10 Consider the above data in 3 columns. 81.151.0 through 81.151.7 does not exist in that data, so concatenation needs to skip those and produce: 81.132.253:81.132.255 81.151.8:81.151.10 All the numbers shown above can only be between...
  3. DannyTEM

    IP range manipulation in Excel?

    I have figured it out, but for the purpose of answering the request...: I'll repaste a sample of the starting data from the original post: Current: 145.45.67 145.45.68 145.45.69 145.45.70 145.45.71 145.45.75 145.45.76 145.45.77 145.46.11 145.46.12 145.46.13 Goal: 145.45.67:145.45.71...
  4. DannyTEM

    IP range manipulation in Excel?

    :) Actually I am having problems with the steps outlined. Col A is blank, Col B is the original data, and columns C, D & E is Col B split into 3 columns delimited. Sorting on column E is okay, but however because both the middle and first number (i.e. 145 & 45 from 145.45.67) also need to be...
  5. DannyTEM

    IP range manipulation in Excel?

    Using the &= tip I have managed to achieve what I mentioned in my second post. With regards to your first post, thats a great tip on Text to Columns (I never knew about it) - the concatenation might take a while as there are a lot of IP's but the time required has been cut into thanks to that...
  6. DannyTEM

    IP range manipulation in Excel?

    Hey Skip - thanks for those replies. I was half way through typing my first reply when you first posted so sorry if you thought I was ignoring your response :) - I'll check them both out. Dan Morgan - www.ski-review.com
  7. DannyTEM

    IP range manipulation in Excel?

    Okay, been thinking about this logically and I figure that instead of C ranges (while this would be great as it would mean much less data/rows) I could duplicate the columns, append .0 to every cell in one and add .255 to every cell in the other, stick a range delimiter like : or - in all cells...
  8. DannyTEM

    IP range manipulation in Excel?

    I am wondering whether the following is possible using a simple function in Excel? I have a column of class C IP ranges like below: 145.45.67 145.45.68 145.45.69 145.45.70 145.45.71 145.45.75 145.45.76 145.45.77 145.46.11 145.46.12 145.46.13 I need them in range format like...
  9. DannyTEM

    IP addresses manipulation in Excel

    I am not worthy, that works perfectly. Thanks ever so much! DT Dan Morgan - www.ski-review.com
  10. DannyTEM

    IP addresses manipulation in Excel

    Hi Tom, Thanks for your reply. Only problem is that the last octet can be 1,2 or 3 numbers long so that solution would only work for some IPs, not all. Cheers anyway, DT Dan Morgan - www.ski-review.com
  11. DannyTEM

    IP addresses manipulation in Excel

    Been trying to find a solution to this one all morning. Have a column of IP's in Excel (for Mac if it makes any difference) and I wanted to shorten them all down to C class level. I.e 255.255.255.255 becomes 255.255.255 I have played with lots of built in functions but because the last...
  12. DannyTEM

    Macro to output all possible inverted phrases

    Thanks for your reply. It is essentially a taxonomy project, I have a list of key phrases and the application requires that all 2 word keyphrases are also present in the column reversed or inverted. Cheers, Dan Dan Morgan - www.ski-review.com
  13. DannyTEM

    Macro to output all possible inverted phrases

    If I have a column containing search keyphrases, is it possible using a VB macro to output all possible inverted 2 keyword phrases if they do not already exist? For example: keywork 1 keyword 2 Would be converted to keyword 2 keyword 1 if the inverted phrase did not exist already in the...
  14. DannyTEM

    MS SBS 2003 - Access to localhost on LAN client

    Thanks for the post - however apart form the apache problem, this PC is perfectly visible under normal networking tasks etc so cables and the switches cannot be to blame - it just does not seem to want to allow access to apache fairly sporadically. Thanks anyway, Dan Dan Morgan -...
  15. DannyTEM

    MS SBS 2003 - Access to localhost on LAN client

    Hi all, We are running MS SBS 2003, ISA enabled. All clients on Win XP Pro. On one of the client machines we have apache installed, which over the past few weeks has been visible but intermittently via http://clientname/ from many of the other clients on the network. Any ideas which may...
  16. DannyTEM

    Anti Virus considerations?

    Thanks Stephen, I looks at the free edition, but it is not free for commercials (we are a small company) and the paid version does not support NT 4 Server. I also looked at AVG for File Servers, however it is aimed at multiple users using the AV, however I just want the server to be protected...
  17. DannyTEM

    Anti Virus considerations?

    Thanks SjrH, The servers role will just be a file/print server. It may become a PDC but at the moment it is doubtful. With regard to McAfee - that looks good - however I do not want a version which controsl all client PCs as well - which from the McAfee site would you recommend - Would...
  18. DannyTEM

    Anti Virus considerations?

    Hi all, Got a Dell Poweredge running NT 4 Server - in this day and age what anti virus precautions do I need to take - is it the same as thinking about a home desktop? Also what would you recommend software wise as NT 4 is not supported by many of the newer titles. Thanks Dan Dan Morgan -...
  19. DannyTEM

    XP/2000 wrkst's connecting to NT4Server under workgroup.

    Hi, This seems to have worked itself out after a random sequence of reboots. However, when I set the "User Must Change Password at Next Logon" option, they are always advised that the old password which they are promted for when asked to change, is wrong - I had to disable this option in order...
  20. DannyTEM

    XP/2000 wrkst's connecting to NT4Server under workgroup.

    In addition if I use the servers default admin login from another workstation it logs in fine - just not when I add other users. Thanks, Dan Dan Morgan - www.ski-review.com

Part and Inventory Search

Back
Top