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 next row.

 

Any help would be very much appreicated.

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 

3 Replies

  • 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 

Resources