Forum Discussion

thenewguy87's avatar
thenewguy87
Copper Contributor
Jun 30, 2023
Solved

I want to replicate a formular with one value remaining the same.

I am looking for some help have this formular that I want to replicate in a colum   =INDEX(C2:I2,MATCH(MAX(C3:I3),C3:I3,0))   I want to keep C2:I2 unchanged in the with only C3:I3 chaning to the ...
Formulas and Functions
  • leoperdia's avatar
    leoperdia
    Jun 30, 2023

    Hi thenewguy87 just include $ before number of row. Like this:

     

    =INDEX(C$2:I$2,MATCH(MAX(C3:I3),C3:I3,0))

     

    Regards

    https://www.upwork.com/freelancers/~01cf0fc8446b00f44c 

leoperdia's avatar
leoperdia
Brass Contributor
Jun 30, 2023

Hi thenewguy87 just include $ before number of row. Like this:

 

=INDEX(C$2:I$2,MATCH(MAX(C3:I3),C3:I3,0))

 

Regards

https://www.upwork.com/freelancers/~01cf0fc8446b00f44c 

  • thenewguy87's avatar
    thenewguy87
    Copper Contributor
    Jun 30, 2023
    Thank you so much. 😄
    • leoperdia's avatar
      leoperdia
      Brass Contributor
      Jun 30, 2023
      you're welcome

Resources