返回列表 发帖
Somewhat of a strange (if not impossible?) Excel question:

I have ten cells, that must equal 1 (100%). How can I generate random percentages in each of those cells that are greater than zero, less than 100%, and populate every cell?

For example, a random pick may be { 3%, 12%, 22%, 10%....and so forth }

Is this possible without VBA?

返回列表