Deleteting duplicates for unique values with matching row values

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.

Instead of splitting use joining :-)

so (following your assumption about data location) in C2 write:

Formula:

Please Login or Register  to view this content.

and copy this formula down (easy way - after writing formula select C2 and double click on filling handle - small black square in bottom-right corner of cell)
Now select A2:C10000 and use delete duplicates but search for duplicates only in column C

Well, as I said: select A2:C10000 and use delete duplicates
So after this you have data only in A2:C5678 (for instance) and data in A2:B5678 is still the original data but with dupes removed. So delete column C content and that's it