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))
If you already have the two values (the letter or letters and the number), you can just search column A for that value and get column B for the same row.
If you connect the find first occurrence of list block with the list of values data source block, you should be able to get the row # you need.
try this
here are the blocks
note: max number letters for the row name is assumed to be 2
here’s the link (use screen 12)
https://x.thunkable.com/copy/ee8744f4f4391584d2292feed675eeaa
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.
