# Auto Numbering

**URL:** <https://community.glideapps.com/t/auto-numbering/20355>\
**Category:** Ask for Help\
**Created:** [December 27, 2020, 9:34pm UTC](https://community.glideapps.com/t/auto-numbering/20355 "2020-12-27T21:34:24Z")\
**Posts on this page:** 1\
**Showing post:** 40

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [March 9, 2021, 2:21pm UTC](https://community.glideapps.com/t/auto-numbering/20355/40 "2021-03-09T14:21:59Z")

</div>

Something like this I guess?

> [@Arrayformula for incremental serial number dependent on another column](https://community.glideapps.com/t/arrayformula-for-incremental-serial-number-dependent-on-another-column/7975/2):
>
> Hi Manan, You can try =ARRAYFORMULA(IF(A2:A\<\>"",COUNTIFS(A2:A,A2:A,ROW(A2:A),"\<="&ROW(A2:A)),"")) Explanation: A2:A\<\>"" : To only number the rows that have data in A COUNTIFS: Only consider rows that have the same project name (A2:A, A2:A) and apply a dynamic range containing only from the start of the column to that specific row (ROW(A2:A), \<=&ROW(A2:A) Please try and get back to me if you need more help. [image]

---

_[View the full topic](https://community.glideapps.com/t/auto-numbering/20355)._