Recent content by DannyTEM

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