Home |
Search |
Today's Posts |
#1
|
|||
|
|||
extract data
hihi i need help how to extract current balance from this current month and store it to the next opening balance for later use.......... every time after i have update thanks -- miles |
#2
|
|||
|
|||
extract data
Let's say your balance column is column D. The column grows each time you
update it, but the current balance is always at the bottom of the column. The formula: =LOOKUP(2,1/(D2:D653560),D2:D65356) will give the value of that cell. Enter it where you need the next openinng balance -- Gary's Student "miles" wrote: hihi i need help how to extract current balance from this current month and store it to the next opening balance for later use.......... every time after i have update thanks -- miles |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to extract data from a cell in a formula in another cell | Excel Worksheet Functions | |||
Charts not recognizing source data if original linked data is changed. | Charts and Charting in Excel | |||
Data extract from access query | Excel Discussion (Misc queries) | |||
Line Graph Data Recognition | Charts and Charting in Excel | |||
Extract Data | Excel Discussion (Misc queries) |