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

"afn" <(E-Mail Removed)> wrote in message
news:a9dc841a-0636-452c-9667-(E-Mail Removed)...
> 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

On Apr 18, 6:57*pm, "Victor Delta" <n...@nospam.com> wrote:
> "afn" <la...@noblesoftwaresolutions.com> wrote in message
>
> news:a9dc841a-0636-452c-9667-(E-Mail Removed)...
>
> > 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.