- UID
- 223346
- 帖子
- 483
- 主题
- 49
- 注册时间
- 2011-7-11
- 最后登录
- 2013-9-12
|
Haha. Yeah....let me guess you are modeling different portfolios.
On one sheet create a sheet of randomly generated nos.
A B C D
1 rand rand rand rand
2 rand rand rand rand
Copy those numbers into another sheet, and paste special the values.
A B C D
1 X S K H
2 G F O Y
On the right most column, sum the prvious nos.
A B C D E
1 X S K H SUM(A1:E1)
2 G F O Y SUM(A2:E2)
In another spreadsheet, divide each cell by the total on the right to get the percentage....
that probably made no sense |
|
发表于 2011-10-14 08:42
|