447130 Customize an Excel Function
This project is now closed with a project budget of N/A.Get free quotes for a project like this
Browse Related Skills
Other things people do on Freelancer
I have attached an Excel visual basic script that has 95% of the functionality I am seeking.
Attached is an Excel spreadsheet (SERP [url removed, login to view]) - the script can be viewed in Excel's Visual Basic editor. If you open it you can see that it queries a specified website for a set of keywords and returns a numerical result based on the website's ranking for that keyword on Google.
What I would like is a modification of this script to create a custom function (i.e. =findrank) to work with the second attached spreadsheet ([url removed, login to view]). Column A is a URL and Column B is a Keyword. The function should take both of these inputs and return a numerical rank based on Google's search engine results.
So the custom function would be something like =findrank(URL,keyword) and would automatically return a dynamic result based on Google's search engine result listings. I am unable to code in Visual Basic but it appears from the functionality of the attached script that this should be very easy to modify.
-The attached script is defaulted to check Google's first 30 results. I'd like this to be customizable.
-The attached script is defaulted to check [url removed, login to view] - I'd like this to be customizable to other Google engines (i.e.: [url removed, login to view], [url removed, login to view], etc.)
Please email me with any questions, suggestions or comments.
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online