Home > Software engineering >  ArrayFormula - Number Partitioning row wise - Attempt to use a single column formula for all rows
ArrayFormula - Number Partitioning row wise - Attempt to use a single column formula for all rows

Time:02-18

Ref enter image description here


Notice that you original solution was simplified and used in here. Simplified original solution is in B3:

=REGEXREPLACE(
  CONCATENATE(
    ArrayFormula(
        REPT(
          INT(SPLIT(A2, ",") / Months) & ",",
          Months - MOD(SPLIT(A2, ","), Months)
        )
      & REPT(
          INT(SPLIT(A2, ",") / Months)   1 & ",",
          MOD(SPLIT(A2, ","), Months)
        )
    )
  ),
  ",$",
)

enter image description here

  • Related