Keyword Density Tool In Excel 25.03.08
Hi,
I need an excel guru to create in excel a template which will automatically count the number of words in an article and to automatically analyse keyword density for 3 chosen keywords per article.
Once the spreadsheet is created all an editor should have to do is copy/pase the article and keywords and a formula in the background should check:
1. Article legth - if above 250 pass if below 250 word in article fail
2. Keyword density - Keyword 1, keyword 2, keyword 3 - if each keyword featured between x% and x% in the article then Pass, if one outside of this threshold then fail
3. If article length pass and keyword density pass - overall pass
Example spreadsheet format attached, you would need to add all the logic to it
This should be very straightforward for someone who knows what they are taking and take an hour max to do
Thanks,
Laurent
