Excel Question?

Just curious in Excel is there a way to find all duplicate rows?

I have an excel sheet I keep adding rows to and I want to find any rows that have the same matching domains some could be www.yoursite.com/index2.html and the other one could be www.yoursite.com/index3.html I just want to find ones that match that are www.yoursite.com?

 

this is pretty easy.

first make a sencond column that filters out the "/**********" whatever and then run an advanced filter
http://office.microsoft.com/en-us/excel/HA010346261033.aspx

 

first of all break the text into columns and apply filter .it might be working....

 

Select the colum then goto Menu - Data - Sort - then click okay you can see it comes alphabetically