clean duplicates in list

hello,

i need to clean a list of ipīs.

the list looks something like this:

677.37.198.243:3128
677.37.198.244:3128
132.72.23.10:3128
133.43.189.20:8080
134.2.205.228:3127
140.112.107.80:3124
140.112.107.80:3128

i want to auto-delete every domain except the top level domains.
so if the first two sets of numbers...
ie.
677.37.198.243:3128
677.37.198.244:3128
677.37.198.245:3128

...are the same, i want to delete every domain except of one.

677.37.198.243:3128

i hope someone can help me out

greetz
frank

What is the unique domain identifier, and what makes it be the top level in a
given domain?

"frank101" wrote:

>
> hello,
>
> i need to clean a list of ipÂīs.
>
> the list looks something like this:
>
> 677.37.198.243:3128
> 677.37.198.244:3128
> 132.72.23.10:3128
> 133.43.189.20:8080
> 134.2.205.228:3127
> 140.112.107.80:3124
> 140.112.107.80:3128
>
> i want to auto-delete every domain except the top level domains.
> so if the first two sets of numbers...
> ie.
> 677.37.198.243:3128
> 677.37.198.244:3128
> 677.37.198.245:3128
>
> ...are the same, i want to delete every domain except of one.
>
> 677.37.198.243:3128
>
> i hope someone can help me out
>
> greetz
> frank
>
>
> --
> frank101
> ------------------------------------------------------------------------
> frank101's Profile: http://www.excelforum.com/member.php...o&userid=24310
> View this thread: http://www.excelforum.com/showthread...hreadid=379167
>
>