Forum Discussion
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.
Hi thenewguy87 just include $ before number of row. Like this:
=INDEX(C$2:I$2,MATCH(MAX(C3:I3),C3:I3,0))
Regards
Hi thenewguy87 just include $ before number of row. Like this:
=INDEX(C$2:I$2,MATCH(MAX(C3:I3),C3:I3,0))
Regards
- Thank you so much. 😄
- you're welcome
