How do you add 2 leading zero to the first column and 1 leading zero to the second column in an array formula?

Question

I have spreadsheet and I need a way to format the formula so that the first column have two leading zeros (000) and the second column to have one leading zero (00) Minimum required code:

=ARRAYFORMULA(
  IF(ISBLANK(C2:C),,
   COUNTIFS(
    C2:C,C2:C,
    ROW(C2:C),"<="&ROW(C2:C))))

Answer 1

To format your columns with leading zeros, you can use the TEXT function in Google Sheets. This function allows you to specify a custom number format. This might work:

=ARRAYFORMULA(
  IF(ISBLANK(C2:C),,
   TEXT(COUNTIFS(
    C2:C,C2:C,
    ROW(C2:C),"<="&ROW(C2:C)), "000")&":"&TEXT(COUNTIFS(
    C2:C,C2:C,
    ROW(C2:C),"<="&ROW(C2:C)), "00")))

Let me know if that works!