Random numbers increasing in value but summing to a specific total

I've used the random number generation suggestion shown in the link below to create a series of random results that always equal 100, which I've used to create totals of any amount but what I'm wondering is if there's a way to make this work such that the numbers down the column can be increasingly larger than the one previous?

I'm hoping to be able to create a table that shows increasing income over time.

Microsoft Community Forum

with RANK function

Try

in J10

=RANDBETWEEN(1,1000)

in J11

=RANDBETWEEN(J10+1,999)

copy down

Both are functional solutions, the Randbetwen solution fits nicely into the same space.

Thank you