# How to get the position number of the alphabet series

**URL:** <https://community.thunkable.com/t/how-to-get-the-position-number-of-the-alphabet-series/2625248>\
**Category:** Questions about Thunkable X\
**Tags:** beginner, help\
**Created:** [October 3, 2023, 8:11am UTC](https://community.thunkable.com/t/how-to-get-the-position-number-of-the-alphabet-series/2625248 "2023-10-03T08:11:17Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![androidswetha\_90](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/androidswetha_90/32/161306_2.png) [@androidswetha\_90](https://community.thunkable.com/u/androidswetha_90)\
**Post date:** [October 3, 2023, 8:11am UTC](https://community.thunkable.com/t/how-to-get-the-position-number-of-the-alphabet-series/2625248/1 "2023-10-03T08:11:17Z")

</div>

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))

![Screenshot 2023-10-03 130832](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/2/b/2b1a9377e2b955938dd1887fb6ecdf3e0a056f50.png)

---

<div class="post-metadata">

**Author:** ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)\
**Post date:** [October 3, 2023, 2:29pm UTC](https://community.thunkable.com/t/how-to-get-the-position-number-of-the-alphabet-series/2625248/2 "2023-10-03T14:29:00Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![manyone](https://avatars.discourse-cdn.com/v4/letter/m/ee59a6/32.png) [@manyone](https://community.thunkable.com/u/manyone)\
**Post date:** [October 3, 2023, 7:42pm UTC](https://community.thunkable.com/t/how-to-get-the-position-number-of-the-alphabet-series/2625248/3 "2023-10-03T19:42:09Z")

</div>

try this  
 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/2/5/25f0005b71a96a4f022ec39a2b5674189ef98d12.png)

here are the blocks

 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/b/e/bec38262e0c618d68b4630ea8334bb2eae9b3cf4.png)

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](https://x.thunkable.com/copy/ee8744f4f4391584d2292feed675eeaa)

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/f/0f59f292712368bce16ff80133ae10de8a6f27e8.png) [@system](https://community.thunkable.com/u/system)\
**Post date:** [January 1, 2024, 7:43pm UTC](https://community.thunkable.com/t/how-to-get-the-position-number-of-the-alphabet-series/2625248/4 "2024-01-01T19:43:02Z")

</div>

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.