How do I generate 10 unique random numbers between 1 and 100 that sum up to 100?

[gnans19]

How do I generate 10 unique random numbers between 1 and 100 that sum up to 100?

Example:

11
23
3
5
18
6
7
8
9
10

–––––––––

            100

––––––––––

[paulfound · Accepted solution]

Had a break and come back to it, think this fills the criteria. 

Enjoyed the challenge.

bit messy and could do with going into macro, but ticks all the boxes I think

[gnans19]

Thank you @paulfound This is amazing. I thought this is an optimization problem and needs LP solution.