Greetings,
I am trying to filter and condense a large list of IP Addresses representing 5 days worth of OWA Access Logs. I’ve paired out all duplicate addresses already, but there are still thousands of unique address entries per day, and I am stumped as to how to condense this information (using Excel) to generate results similar to the following:
Original List:
10.13.XXX.XXX
10.13.XXX.XXX
10.17.XXX.XXX
10.17.XXX.XXX
10.17.XXX.XXX
10.5.XXX.XXX
13.10.XXX.XXX
13.10.XXX.XXX
13.10.XXX.XXX
13.10.XXX.XXX
120.104.XXX.XXX
120.104.XXX.XXX
120.104.XXX.XXX
Desired Filtered/Condensed List:
Column A Column B
10.13.XXX.XXX 1
10.17.XXX.XXX 3
10.5.XXX.XXX 1
13.10.XXX.XXX 4
120.104.XXX.XXX 3
I am simply trying to determine how many visits total on any given day originated from various subnets, but I am not having any luck getting Excel to generate the output I am looking for. Any help would be very much appreciated.
Signed,
Adam “Excel’Clueless”