Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with code
I have a couple hundred lines of Check Amts and Check Numbers (as text)
like below.. I need to Loop from bottom to top and Sum the previous amts applicable to The same check number. Bottom line ColA should = 12660; 2 rows up should = 1,583.96, etc up to Row 2. Can someone get me started? TIA, ColA ColB 197.11 65704 65704 78.03 65705 65705 27.85 65706 1691.84 65706 122.98 65706 2275.13 65706 289.95 65706 65706 372.22 65707 57.96 65707 921.05 65707 232.73 65707 65707 12660 65709 65709 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with code
Rather than fill in the empties with the sums of the items above, consider
using a pivot table which results in : Sum of amount num Total 65704 197.11 65705 78.03 65706 4,407.75 65707 1,583.96 65709 12,660.00 Grand Total 18,926.85 -- Gary''s Student "JimMay" wrote: I have a couple hundred lines of Check Amts and Check Numbers (as text) like below.. I need to Loop from bottom to top and Sum the previous amts applicable to The same check number. Bottom line ColA should = 12660; 2 rows up should = 1,583.96, etc up to Row 2. Can someone get me started? TIA, ColA ColB 197.11 65704 65704 78.03 65705 65705 27.85 65706 1691.84 65706 122.98 65706 2275.13 65706 289.95 65706 65706 372.22 65707 57.96 65707 921.05 65707 232.73 65707 65707 12660 65709 65709 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
split post code (zip code) out of cell that includes full address | Excel Discussion (Misc queries) | |||
Code to conditional format all black after date specified in code? | Excel Discussion (Misc queries) | |||
Drop Down/List w/Code and Definition, only code entered when selec | Excel Worksheet Functions | |||
Code stops when high lighting (Chips code) | Excel Programming | |||
stubborn Excel crash when editing code with code, one solution | Excel Programming |