Generate random numbers that add up to a certain amount in excel

Get random numbers to add up to a set number

[@TheBasket1234]

Could you explain please how to use these formula without repeated/duplicated values? Thank you!