Alright, please download this excel sheet here http://www.mediafire.com/?nfi7ycvnza3ieit - Its only 24kb.
Now this is a very real world situation and will surely help thousands of people. 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.
Bookmarks