Delete rows based on a set of cells in the same order

Hi everyone,

I have a huge list of 17.000 URLs which I have to clean up. The list contains several 'blocks' which contain the same URLs in the same order, e.g.:

URL 1
URL 1
URL 2

I would like Excel to go through the list (column) and delete the rows where this 'block' is found, so all three rows of this block should be removed. These blocks vary from 3 URLs to 90 URLs. Is it possible to let Excel do this for me? And if so, how can I achieve it.

I am not an Excel expert, so I am not familiar with macros/VB (although I am open to learn about it of course!)

With kind regards,
Iljoesjin

Hi ImranBhatti,

Please see the file attached, the first sheet shows the original list with the 'blocks' marked in red. These should be removed from the list, as shown on the second sheet. In the example is used a block of 3 URLs, in the real list I also have blocks from 90 URLs which have to be removed.

I hope this clarifies things, otherwise please let me know what additional information you need.

With kind regards,
Iljoesjin

I replaced the actual URLS with 'URL #' in the example, so in the real version the identifier will probably be the full URL since they belong to the same domain. So for the 'block' of 90 it will mean 90 different URLS in a specific order.

I hope this answers your question.

I am afraid that is too sensitive indeed. Perhaps this background information helps: I used a spider tool to crawl a website on its pages and the connections between them and this was exported into a .csv file. The tool also shows all links to the pages in the top navigation and footer of the pages, I want to eliminate those because they are not relevant for my research (since they are available for every page).

Example URLs:
http://www.company.com/main/products/product-type1.html
http://www.company.com/main/products/product-type2.html
http://www.company.com/main/products/product-type3.html
http://www.company.com/main/products/product-type4.html
... (this goes on for about 20 product categories)
http://www.company.com/main/application1.html
http://www.company.com/main/application2.html
http://www.company.com/main/application3.html
http://www.company.com/main/application4.html
... (this goes on for about 30 application areas)
http://www.company.com/main/support/faq.html
http://www.company.com/main/support/warranty.html

The order and amount of URLs is always the same since, the top navigation menu (and footer) do not change per page.

I hope this helps, otherwise I will do it manually (but that would take a lot more time). Thanks anyways!