Hello,
I am OK at Excel but I have never really attempted at writing VB code. My expertise is really PHP and a bit of Java so bear with me... anyway to the question:
I have a spreadsheet of thousands of rows of websites with their IPs. What I need to do is calculate the number of unique SubNets within that column (i.e. 154.124.60 is one subnet regardless of there being multiple 154.124.60.x).
Essentially the only way I can figure out to do it is to split each cell to remove the last part of the ip then to manually remove duplicates using the function in excel. This will give me how many unique sub nets there are.
Then I want to find out how many of each appear so I would need to do a count function to see how many times each one of these appear in the column of IPs.
The problem with this is that I will be doing this every couple of weeks and so it will take a hell of a lot of time to do this manually.
I was wondering if there is an automated way?
Has anyone tried something similar before who wouldn't mind enlightening me, or alternatively point me in the direction of a few tutorials that would help me achieve this through VB/Macros?
I know from other forums that people don't like OPs not trying to do this on their own first but I have no knowledge of VB and I do not really have the time to study it (its a work project) so I do apologise not having a crack at this first.
Any help will be greatly appreciated.
I am OK at Excel but I have never really attempted at writing VB code. My expertise is really PHP and a bit of Java so bear with me... anyway to the question:
I have a spreadsheet of thousands of rows of websites with their IPs. What I need to do is calculate the number of unique SubNets within that column (i.e. 154.124.60 is one subnet regardless of there being multiple 154.124.60.x).
Essentially the only way I can figure out to do it is to split each cell to remove the last part of the ip then to manually remove duplicates using the function in excel. This will give me how many unique sub nets there are.
Then I want to find out how many of each appear so I would need to do a count function to see how many times each one of these appear in the column of IPs.
The problem with this is that I will be doing this every couple of weeks and so it will take a hell of a lot of time to do this manually.
I was wondering if there is an automated way?
Has anyone tried something similar before who wouldn't mind enlightening me, or alternatively point me in the direction of a few tutorials that would help me achieve this through VB/Macros?
I know from other forums that people don't like OPs not trying to do this on their own first but I have no knowledge of VB and I do not really have the time to study it (its a work project) so I do apologise not having a crack at this first.
Any help will be greatly appreciated.
