Complete Macro noob here...
I am working with a very large data set (5,000+ rows, 57 columns) of web server logs. These logs contain a great deal of noise I need cleaned out. The best column to do this from would be the Destination IP addresses. There are over 250 unique addresses. I need to strip out 137 unique addresses and the entire row associated with each to isolate specific browsing behavior. I figured a vlookup from another sheet would work. But I'm not positive.
The format of this column is as follows:
<tbody>
</tbody>
(Disclaimer: These are random made up IPs, most of which are not in valid format to protect privacy).
I am working with a very large data set (5,000+ rows, 57 columns) of web server logs. These logs contain a great deal of noise I need cleaned out. The best column to do this from would be the Destination IP addresses. There are over 250 unique addresses. I need to strip out 137 unique addresses and the entire row associated with each to isolate specific browsing behavior. I figured a vlookup from another sheet would work. But I'm not positive.
The format of this column is as follows:
DestinationIP |
DestIP="111.222.133.44" |
DestIP="33.44.66.77" |
DestIP="125.89.143.23" |
DestIP="76.945.34.87" |
DestIP="45.347.33.89" |
DestIP="44.3.22.454" |
DestIP="130.79.142.56" |
DestIP="87.56.23.17" |
DestIP="52.34.576.34" |
DestIP="53.55.123.45" |
<tbody>
</tbody>
(Disclaimer: These are random made up IPs, most of which are not in valid format to protect privacy).