# Arrayformula for incremental serial number dependent on another column

**URL:** <https://community.glideapps.com/t/arrayformula-for-incremental-serial-number-dependent-on-another-column/7975>\
**Category:** Ask for Help\
**Created:** [April 27, 2020, 9:38pm UTC](https://community.glideapps.com/t/arrayformula-for-incremental-serial-number-dependent-on-another-column/7975 "2020-04-27T21:38:27Z")\
**Posts on this page:** 1\
**Showing post:** 2

<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:** [April 28, 2020, 12:47am UTC](https://community.glideapps.com/t/arrayformula-for-incremental-serial-number-dependent-on-another-column/7975/2 "2020-04-28T00:47:01Z")

</div>

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](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/a/a9361c1ac67f58a8254ac33f107855e5a268f69c.png)

---

_[View the full topic](https://community.glideapps.com/t/arrayformula-for-incremental-serial-number-dependent-on-another-column/7975)._