Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi,
I need to assign weights to three groups. W1 , W2, and W3. Summation of weights will always be 1.0. How one can assign weights with respect to a discrete level . Example if the discrete level is 0.5 then options for W1, W2, and W3 can be 1 , 0, 0 0, 1, 0 0, 0, 1 0.5, 0.5 , 0 0.5, 0, 0.5 0, 0.5, 0.5 I was wondering if we can automate the process of assigning weights for higher discrete level. Example, 0.1 or even lesser. My apologies if I am not clear in explaining the problem. I will appreciate any replies. Thank you so much. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Automate pivot table selection | Excel Discussion (Misc queries) | |||
Copy Selection - Transpose Selection - Delete Selection | Excel Discussion (Misc queries) | |||
Identifying a selection of a selection of a range | Excel Worksheet Functions | |||
Automate selection of specific reference cells | Excel Discussion (Misc queries) | |||
Automate column selection | Setting up and Configuration of Excel |