Stryker2013
New Member
- Joined
- Jul 22, 2013
- Messages
- 40
i have a spreadsheet with multiple columns. One of these columns have a numeric value. I want excel to group the data based on a sum on this column. example: each line has 2 columns, one a name and one a value (which is a point).
line 1 apples 5
line 2 pears 3
line 3 grapes 4
line 4 grapes 2
line 5 apples 7
line 6 tomatoes 4
line 7 peaches 8
I want it to group my line by subtotaling every 10 points or less. so the result I am looking for is as follows:
line 1 apples 5
line 2 pears 3
line 3 grapes 2
subtotal 10
line 4 grapes 4
subtotal 4
line 5 apples 7
subtotal 7
line 6 tomatoes 1
line 7 peaches 8
subtotal 9
Any ideas?
line 1 apples 5
line 2 pears 3
line 3 grapes 4
line 4 grapes 2
line 5 apples 7
line 6 tomatoes 4
line 7 peaches 8
I want it to group my line by subtotaling every 10 points or less. so the result I am looking for is as follows:
line 1 apples 5
line 2 pears 3
line 3 grapes 2
subtotal 10
line 4 grapes 4
subtotal 4
line 5 apples 7
subtotal 7
line 6 tomatoes 1
line 7 peaches 8
subtotal 9
Any ideas?