| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Weighted randbetween text list
Awesome! Thanks for the further pointers. After analyzing your formula it led me to the following:
=lookup(randbetween(1,sum(B2:B6)),C2:C6,A2:A6) column C has a running sum of B, i.e. C2=sum(0,B2), C3=sum(C2,B3), etc. In my formula column B is the weighted values, column A is the values, column C is the running total of B |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding the weighted average of text that have been given values | Excel Worksheet Functions | |||
| randbetween(1.1,1.25) | Excel Worksheet Functions | |||
| randbetween | Excel Discussion (Misc queries) | |||
| Randbetween | Excel Discussion (Misc queries) | |||
| randbetween gives ?NAME | Excel Discussion (Misc queries) | |||
Hybrid Mode
