| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
return sporadic numbers in a cell-area from a spesific number
Hi - i have a job to do and i have 30 days (cells) and a number - eks 200 -
i want to spread out sporadic numbers in the 30 cells and the summary must be 200.I know you proffesionals out there can tell me! I`ll be pleased Peter |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
return sporadic numbers in a cell-area from a spesific number
In A1 thru A29 enter:
=RANDBETWEEN(1,10) In A30 enter: =200-SUM(A1:A29) -- Gary''s Student - gsnu2007g "farmer" wrote: Hi - i have a job to do and i have 30 days (cells) and a number - eks 200 - i want to spread out sporadic numbers in the 30 cells and the summary must be 200.I know you proffesionals out there can tell me! I`ll be pleased Peter |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
return sporadic numbers in a cell-area from a spesific number
Don`t work - i get #name?
"Gary''s Student" skrev i melding ... In A1 thru A29 enter: =RANDBETWEEN(1,10) In A30 enter: =200-SUM(A1:A29) -- Gary''s Student - gsnu2007g "farmer" wrote: Hi - i have a job to do and i have 30 days (cells) and a number - eks 200 - i want to spread out sporadic numbers in the 30 cells and the summary must be 200.I know you proffesionals out there can tell me! I`ll be pleased Peter |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
return sporadic numbers in a cell-area from a spesific number
If this function is not available, and returns the #NAME? error, install and
load the Analysis ToolPak add-in. Use: Tools AddIns... -- Gary''s Student - gsnu2007g "farmer" wrote: Don`t work - i get #name? "Gary''s Student" skrev i melding ... In A1 thru A29 enter: =RANDBETWEEN(1,10) In A30 enter: =200-SUM(A1:A29) -- Gary''s Student - gsnu2007g "farmer" wrote: Hi - i have a job to do and i have 30 days (cells) and a number - eks 200 - i want to spread out sporadic numbers in the 30 cells and the summary must be 200.I know you proffesionals out there can tell me! I`ll be pleased Peter |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
return sporadic numbers in a cell-area from a spesific number
Ok now but the solution doesn work - the number i put in cell a 31 must be
ditributed randomly from cell A1 to A30 so the summary of A1 to A30 must be like A31 "Gary''s Student" skrev i melding ... If this function is not available, and returns the #NAME? error, install and load the Analysis ToolPak add-in. Use: Tools AddIns... -- Gary''s Student - gsnu2007g "farmer" wrote: Don`t work - i get #name? "Gary''s Student" skrev i melding ... In A1 thru A29 enter: =RANDBETWEEN(1,10) In A30 enter: =200-SUM(A1:A29) -- Gary''s Student - gsnu2007g "farmer" wrote: Hi - i have a job to do and i have 30 days (cells) and a number - eks 200 - i want to spread out sporadic numbers in the 30 cells and the summary must be 200.I know you proffesionals out there can tell me! I`ll be pleased Peter |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding area codes only to phone numbers missing an area code | Excel Discussion (Misc queries) | |||
| How can I automatically add an area code to a number in a cell? | Excel Worksheet Functions | |||
| How to find number of hours past a spesific time | Excel Discussion (Misc queries) | |||
| In a column of numbers, how do I return the last non-zero number? | Excel Discussion (Misc queries) | |||
| return largest number of a list of numbers in the same cell | Excel Worksheet Functions | |||
Linear Mode
