Hey everyone, I have a question that may not have an easy answer and through searching have found no solution that matches my position.
I have a list of IP address and corresponding values related to them in two colums.
For solutions, just assume the data is in A2:B10000
Example:
IP 1 Value 1 IP 1 Value 1 IP 1 Value 2 IP 2 Value 1 IP 2 Value 2 IP 3 Value 2
Is there a way to find and delete the duplicate values for each IP while maintaining the unique values for each IP address?
I know that I could split the table by individual IP address and use Delete Duplicates. This was what I did last time and it took hours because I needed the data that day, have hundreds of IP addresses, and didn't have time to do research.
I appreciate any help and am somewhat familiar with MS Visual Basics if that would provide the most robust solution.
Bookmarks