How To Test If The Target Keyword Is Included In A Given Content In Excel?
Use this formula in Excel to find if the target keyword is included in a given content.
This is particularly useful when auditing the Title tag, H1 and H2 elements.
Copy and paste the following formula in column C
=SUMPRODUCT(COUNTIF(A2,"*"&$B$2:$B$11&"*"))>0
Video description for this formula
Video: how to bulk check H1 and H2 – real SEO example
Reference:
http://stackoverflow.com/questions/20892499/check-if-a-cell-contains-values-from-a-list
I am an SEO consultant who happens to be interested in affiliate marketing.
I build websites and use them for testing various SEO strategies and tactics.
LinkedIn Profile
I build websites and use them for testing various SEO strategies and tactics.
LinkedIn Profile
Latest posts by Tony (see all)
- How To Track Keyword Ranking? - April 27, 2020
- Is Updating Old Content For SEO Worth It? - March 30, 2020
- What Is Remote Desktop Access (a.k.a RDP Or VPS) For SEO? - March 27, 2020
Leave a Reply
Want to join the discussion?Feel free to contribute!