Technology Matrix to Single Cell

To get the first technology result from the matrix into a single cell next to the domain do the following -

  • Create a new column after the Domain column in the Matrix File of Interest
  • In B2 enter the following formula - =INDIRECT(ADDRESS(1,MATCH("x",C2:ZZ2,0)+2))
  • Copy this line to the bottom of your spreadsheet

Related Articles in Excel Tips Category

Export BuiltWith Profiles to Excel/CSV

Export BuiltWith Profiles to Excel/CSV

You can export website profiles you see in BuiltWith to CSV and XSLX formats as shown below -The simplest way to do this is to click the CSV/XLSX link on profiles....

How to get Domain from Email

How to get Domain from Email

If your email address is in cell A1 (top left cell) the formula to use to get just the domain part is as follows - =RIGHT(A1,LEN(A1)-FIND("@",A1)) This works for....