This question is similar to this question posted earlier. The difference is that I want to change value in a cell that index column is not unique. For example:
x y
A 1 5
B 4 6
C 0 3
C 5 9
I want to replace 9 with 100 and get:
x y
A 1 5
B 4 6
C 0 3
C 5 100
Any suggestions?