Read this full article https://excelmanblog.blogspot.com/2021/07/ways-of-adding-automatic-serial-numbers.html Download Working File https://docs.google.com/spreadsheets/d/1oOXusv31xyzjuf8ERciq1YEcYWhYhGaK/edit?usp=sharing&ouid=110112042724058527090&rtpof=true&sd=true