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
Technology Matrix to Single Cell
Read More →