Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Add columns to reach a predetermined value
I'm working on spreadsheet that has 1000's of rows and want to be
able to add up a column until it reaches, for example, 900. And then take the next set and of rows and do the same. So that there are several rows "grouped" that the sum of the values in the particular column is 900. As well there will be times after the first "grouping" is set the numbers will change so the the procedure will have to redone. OR there maybe times that the list needs to sorted/filtered and again sum the rows until 900 is reached. Also there maybe times when the value of 900 may need to be changed to a different #. Below is a very simplified example of what I need....thanks, in advance, for assistance. A B Widgets 100 Things 500 More things 300 Total 900 Pieces 500 Widgets 200 things 200 Total 900 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Add columns to reach a predetermined value
"afn" wrote in message
... I'm working on spreadsheet that has 1000's of rows and want to be able to add up a column until it reaches, for example, 900. And then take the next set and of rows and do the same. So that there are several rows "grouped" that the sum of the values in the particular column is 900. As well there will be times after the first "grouping" is set the numbers will change so the the procedure will have to redone. OR there maybe times that the list needs to sorted/filtered and again sum the rows until 900 is reached. Also there maybe times when the value of 900 may need to be changed to a different #. You could use conditional formatting to show the groups in different colours. i.e. set the CF so that the cells in the number column show say a yellow pattern when the number is 1-900, red for 901-1800, blue for 1801 - 2700 etc V |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Add columns to reach a predetermined value
On Apr 18, 6:57*pm, "Victor Delta" wrote:
"afn" wrote in message ... I'm working on spreadsheet that has 1000's of rows and want to be able to add up a column until it reaches, for example, 900. And then take the next set and of rows and do the same. So that there are several rows "grouped" that the sum of the values in the particular column is 900. As well there will be times after the first "grouping" is set the numbers will change so the the procedure will have to redone. OR there maybe times that the list needs to sorted/filtered and again sum the rows until 900 is reached. Also there maybe times when the value of 900 may need to be changed to a different #. You could use conditional formatting to show the groups in different colours. i.e. set the CF so that the cells in the number column show say a yellow pattern when the number is 1-900, red for 901-1800, blue for 1801 - 2700 etc V Thanks but I still need to figure out how it will add automatically add up each set up 900 - there will be multple rows that will add up to 900. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
predetermined answer in next cell | Excel Worksheet Functions | |||
Calculate value closest to predetermined % | Excel Discussion (Misc queries) | |||
Advance to predetermined cell | Excel Worksheet Functions | |||
Advance to predetermined cell | Excel Worksheet Functions | |||
How to balance several cells to a predetermined value | Excel Discussion (Misc queries) |