Hello,
On the left hand side I have the array, blue numbers, and on the right hand side where those blue numbers should be placed according to the sequence of a letter.
For instance, if an A is the 1st A than place 10 in the 3rd column.
if an A is the 2nd A than place 20 and so on..
However, when I change the 5th A to a 1st B than (in the 5th row right hand side) the number should change from 50 to 10 in the 5th row. Therefore, 6th row B is going to be the second B once I changed, so number should be change from 10 to 20 and 7th row B should be 20 to 30.
Which function I can use DGET, INDEX or smght cooler
? Can anyone help me please?
Thank you so much for the help in advance!
Best regards,
Gkhn
On the left hand side I have the array, blue numbers, and on the right hand side where those blue numbers should be placed according to the sequence of a letter.
For instance, if an A is the 1st A than place 10 in the 3rd column.
if an A is the 2nd A than place 20 and so on..
However, when I change the 5th A to a 1st B than (in the 5th row right hand side) the number should change from 50 to 10 in the 5th row. Therefore, 6th row B is going to be the second B once I changed, so number should be change from 10 to 20 and 7th row B should be 20 to 30.
Which function I can use DGET, INDEX or smght cooler
? Can anyone help me please?Thank you so much for the help in advance!
Best regards,
Gkhn
