I am looking to simplify my current setup, if possible with a single array formula to produce the following result.
I want to have a column with
Please See attached current setup.
Try this out
=LET(s,SEQUENCE(C4/1000-1,1,1000),VSTACK(s,C4-SUM(s)))
See LET and VSTACK
LET
VSTACK