Solved how to remove duplcicate urls ?

Microsoft Office 2007 professional - pac...
December 18, 2013 at 00:17:08
Specs: Windows XP, Dual Core
Problem : i've a list of 1 million+ urls in excen 2007, Domain is same in most of entries

for example :

http://abcde.com/url1
http://abcde.com/url2
http://abcde.com/url3
http://uvxyz.com/url1
http://uvxyz.com/url2
http://uvxyz.com/url3
http://mebola.net/url1
http://mebola.net/url2
http://mebola.net/url3
http://mebola.net/url4

now i want to keep only 1st url and remove others

result should be like this

http://abcde.com/url1
http://uvxyz.com/url1
http://mebola.net/url1

i think a macro can remove duplicate entries for sure... and it will be the best if macro
can remove "url1" also

programming minds can help me


See More: how to remove duplcicate urls ?

Report •

#1
December 18, 2013 at 04:08:26
It sounds like all you want is a list of unique domains.

If so, first use the Text To Columns feature, delimited by the / to separate the URLs into pieces. Then use the Filter feature on the column with the domains and check the Unique Records Only box.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
December 18, 2013 at 04:21:58
Hi Dardy,

Can you please gimme any macro or function to do this, i am now very much familiar with excel


Report •

#3
December 18, 2013 at 05:54:27
✔ Best Answer
You said: "i am now very much familiar with excel"

Did you mean "i am not very much familiar with excel"?


I'm not sure why you want a macro when a simple process within Excel itself will give you the list of unique domains. If you are not very familiar with Excel, then consider the process below as a learning experience. Once you are familiar with the Text To Columns and Filter features, you'll be able to use them in the future.

If we simply provide a macro, you won't learn very much.

The process below looks like a lot of steps, but it actually very simple.

Let's assume your list of URLs is in Column A

1 - Select Column A
2 - Click the Data ribbon
3 - Click Text To Columns
4 - Click Next
5 - Put a / in the Other box
6 - Click Finish

You should now have a list of all Domains in Column C

7 - Select Column C
8 - On the Data ribbon, click Advanced (next to the Filter funnel)
9 - If you don't have a Column label in C1, you might get a Warning message. Just Click OK if you do.
10 - In the Advanced Filter dialog box click "Copy to another location"
11 - Enter E1 (or any other single cell reference) in the "Copy To" field
12 - Check the "Unique records only" box
13 - Click OK

In Column E you should now have a list of Unique domains.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

Related Solutions

#4
December 18, 2013 at 08:35:59
This should tell you everything you need to know:

http://www.wikihow.com/Write-a-Simp...


Report •

#5
December 18, 2013 at 16:36:30
I'm curious...

How will that site tell him everything he needs to know?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

Ask Question