in text box i will input the alphabet single letter or double letter ,
now i want to get the position number of the alphabet in label 1
for example if i enter (A = 1 , B=2 ,C=3 ,…Z=26 , AA = 27 , AB = 28 , AC = 29 …ZZ = 702 .
i am using these formulas in excel to get the position number of the alphabet series , formula used in excel to get the position number of the alphabet series = =SUMPRODUCT((CODE(MID(A2,LEN(A2)-ROW(INDIRECT(“1:”&LEN(A2)))+1,1))-64)*26^(ROW(INDIRECT(“1:”&LEN(A2)))-1))
you can do this without any use of alphabets you can simply set one column to store indexes of the column by using functions of sheets for example when each time you store a value to a row for example ["Name" , "age" , "job" , "=ROW()" ]
=================> This will store values in Row like this ["Name" , "age" , "job" , index ]
and this index will automatically updated while deleting or adding new row like this :
