參考
請注意,您的原始解決方案已簡化并在此處使用。簡化的原始解決方案在B3:
=REGEXREPLACE(
CONCATENATE(
ArrayFormula(
REPT(
INT(SPLIT(A2, ",") / Months) & ",",
Months - MOD(SPLIT(A2, ","), Months)
)
& REPT(
INT(SPLIT(A2, ",") / Months) 1 & ",",
MOD(SPLIT(A2, ","), Months)
)
)
),
",$",
)

轉載請註明出處,本文鏈接:https://www.uj5u.com/qiye/428207.html
