Matriz tecnológica a célula única

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








Consejos de Excel
Artículo heredado
Este es un artículo heredado de la Base de conocimientos.
Hojas de cálculo de Google
Centro de inversores