Search results for query: *

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...

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...

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...

:) 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...

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...

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

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...

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...

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

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

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...

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

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...

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 -...

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...

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...

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...

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 -...

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...

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