Hoping someone out there will be able to help me with this...
I have a sheet of records, IP addresses and a count of how many times
each IP appear in the list, that looks something like:
Code:
--------------------
192.168.0.1 1
192.168.0.2 1
192.168.0.2 2
192.168.0.2 3
192.168.0.3 1
192.168.0.3 2
--------------------
and so on. I have Excel (2003) sorting the IP addresses for me and the
count of duplicates all by itself, but the one thing I don't know how
to make it do is remove all the duplicates, leaving the duplicate with
the highest count.
Any suggestions?
--
mlcrane
------------------------------------------------------------------------
mlcrane's Profile:
http://www.excelforum.com/member.php...o&userid=26670
View this thread:
http://www.excelforum.com/showthread...hreadid=399437