Find Unique URLs

**excelkid** · 11-20-2011, 09:13 PM

Alright, please download this excel sheet here http://www.mediafire.com/?nfi7ycvnza3ieit - Its only 24kb.

In optimizing a website, we do keyword analysis. When we are done with final keywords, there comes the stage of competition analysis.

For that purpose, I've made this excel sheet and need some help from excel gurus. Column B from Sheet 1 will have all the final keywords. Column C shows the top 10 URL's for these keywords. Right now, sample data is used but just so you can understand what needs to be done.

Now on sheet 2, in Column A, it should show all the unique URL's from Sheet 1 - Column C. On Sheet 2, in Column B, it should show the number of occurrences for each URL. Once that is done, we need to list the keywords from C3 automatically, from Sheet 1 Column B. When all of these keywords are listed, it should show Sheet 1 Column D ranking position for each URL under the respective keywords cell. If some URL is not listed for any keyword, it should be empty.

Hope that sounds doable? It sounds very difficult to me but am a new member here and from the kind of experts I've seen here. I have high hopes friends!

Thank you so much.

**excelkid** · 11-20-2011, 09:21 PM

For those of you who need an attachment here for the file, please download here

**arlu1201** · 11-21-2011, 11:36 AM

Its a lil confusing to understand the requirement. How are you arriving at the values in Sheet 2 column B?

**excelkid** · 11-21-2011, 01:22 PM

Well, I am basically finding the common URL's out of them all and then arriving at Sheet 2 Column B. Thank you so much ar1201, but this is solved now. So its fine, i don't need any help here now. Thanks a lot though.

If you can help, please help me solve this http://www.excelforum.com/excel-prog...-rankings.html