I have an excel worksheet that in column A has an IP Address, and column B has a userid. If the user visits the same site multiple times, obviously there would be multiple entires in the worksheet for that.
I need a way to get rid of all duplicates. Sample data is like this
Of course the production data sheet has more than 6 rows, but this is for illustration purposes.
I need a way to get rid of all duplicates. Sample data is like this
Code:
11111111 a12
22222222 a12
11111111 a12
33333333 a12
44444444 a12
11111111 a12
Of course the production data sheet has more than 6 rows, but this is for illustration purposes.