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 |
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 |