Start auto-numbering from a chosen row

ALAIN-STEPHANE

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 auto-numbers ( Code livrable ) . But I want auto-numbering starting from the row number 3 whil row number 1 and number 2 remains empty .

Is that possible ?

Thanks in advance .

Paul Newcome

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.

Paul Newcome

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.

ALAIN-STEPHANE

Thanks @Paul Newcome !

I will try it .

Regards .