- Extract all links on a page: "//@href";
- Extract all internal links on a page: "//a[contains(@href, 'domain.com')]/@href";
- Extract all external links on a page: "//a[not(contains(@href, 'domain.com'))]/@href";
- Extract meta description: "//meta[@name='description']/@content";
- Extract H1: "//h1";
- Extract email address(es) from page: "//a[contains(@href, 'mailTo:') or contains(@href, 'mailto:')]/@href";
- Extract social profiles (i.e. LinkedIn, Facebook, Twitter):"//a[contains(@href, 'linkedin.com/in') or contains(@href, 'twitter.com/') or contains(@href, 'facebook.com/')]/@href";
- Extract lastBuildDate (from RSS feed): "//lastBuildDate"
=LEFT(F12,(FIND(" (",F12,1)-1))
Find text before " (" in cell F12
Find text before " (" in cell F12
=COUNTIF(L$2:L,L2)
Count nr. duplicate in table L
Count nr. duplicate in table L
