Try this in C2
=RANDBETWEEN(0,10)
then this in c3 and drag down
=RANDBETWEEN(0,10-SUM(C$2:C2))
but it does tend to bias the top cells.
Try this in C2
=RANDBETWEEN(0,10)
then this in c3 and drag down
=RANDBETWEEN(0,10-SUM(C$2:C2))
but it does tend to bias the top cells.
Happy with my advice? Click on the * reputation button below
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks