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

Read More

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 all versions of Excel.

Read More