• 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
=COUNTIF(L$2:L,L2)

Count nr. duplicate in table L