Start autonumbering from a chosen row
Good morning everybody ;
As show in the picture below , I have a project schedule which starts from the row number 3 and I have a coulumn which contains autonumbers ( Code livrable ) . But I want autonumbering starting from the row number 3 whil row number 1 and number 2 remains empty .
Is that possible ?
Thanks in advance .
Best Answer

You would need to either manually enter it or use a formula in a text/number type of column. The formula would look something along the lines of...
="LIVR" + IF(COUNTIFS(Livrables$3:Livrables@row, OR(@cell = "", @cell <> "")) < 10, "000", IF(COUNTIFS(Livrables$3:Livrables@row, OR(@cell = "", @cell <> "")) < 100, "00", IF(COUNTIFS(Livrables$3:Livrables@row, OR(@cell = "", @cell <> "")) < 1000, "0"))) + COUNTIFS(Livrables$3:Livrables@row, OR(@cell = "", @cell <> ""))
Enter that into Row 3 and then dragfill down.
Answers

You would need to either manually enter it or use a formula in a text/number type of column. The formula would look something along the lines of...
="LIVR" + IF(COUNTIFS(Livrables$3:Livrables@row, OR(@cell = "", @cell <> "")) < 10, "000", IF(COUNTIFS(Livrables$3:Livrables@row, OR(@cell = "", @cell <> "")) < 100, "00", IF(COUNTIFS(Livrables$3:Livrables@row, OR(@cell = "", @cell <> "")) < 1000, "0"))) + COUNTIFS(Livrables$3:Livrables@row, OR(@cell = "", @cell <> ""))
Enter that into Row 3 and then dragfill down.

Help Article Resources
Categories
Check out the Formula Handbook template!