macro to detect domain names (in url's) ?

Hello friends,
I have an excel file with a single column, this column has 32 rows, each row has a url in it
If you look at column A you will see that sometimes the same domain name appear more than a single time (for example: domain1.com/kjh54asfdasd.html, domain1.com/asd.html, and so on...) while some other times the domain name appear only once (for example: domain3.com/kjhgfjasfdasd.html).


My question:

Is there a way to make a macro that will do the following 2 things:

1. Detect all domain names on column A from within the url's (for example: if the url is example.net/aaaaa.asp - then the macro detect example.net as the domain of the url), the detection should support the following domain type: .com, .net, .info, .org, .edu

2. Extract the first 3 instances of each domain name on column A (together with the entire url) and copy them to column B
If some domains has less than 3 instances - the macro will copy them as well


Please see file attached so you see what I mean.