Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sorted running balance
i have a sheet with a running balance. This running balance is for all
clients. I need a formula that will recalculate the running balance when i sort a client. The running balance formula keeps track of the hidden rows giving me a false balance for that client. Need that to be able to print statement history with running balance per client. -- Dietrich |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
sorted running balance
I think you mean "filter" a client.
See help on the SUBTOTAL function. =SUBTOTAL(9,A1:A200) will total only visible rows after filtering. Gord Dibben MS Excel MVP On Tue, 18 May 2010 20:04:01 -0700, Dietrich wrote: i have a sheet with a running balance. This running balance is for all clients. I need a formula that will recalculate the running balance when i sort a client. The running balance formula keeps track of the hidden rows giving me a false balance for that client. Need that to be able to print statement history with running balance per client. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
sorted running balance
I do mean "filter" but I don not want to use the subtotal funtion.
i need a running balance formulla that will show me the running balance when i filter a client. Want to be able to see all clients transaction with running balance after each transaction. The normal running balance formula is not usable when I filter a client. Do you know a formula that will calculate running balance even when filtered? Thanks, I am stock on this one. -- Dietrich "Gord Dibben" wrote: I think you mean "filter" a client. See help on the SUBTOTAL function. =SUBTOTAL(9,A1:A200) will total only visible rows after filtering. Gord Dibben MS Excel MVP On Tue, 18 May 2010 20:04:01 -0700, Dietrich wrote: i have a sheet with a running balance. This running balance is for all clients. I need a formula that will recalculate the running balance when i sort a client. The running balance formula keeps track of the hidden rows giving me a false balance for that client. Need that to be able to print statement history with running balance per client. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
running balance | Excel Worksheet Functions | |||
Running Balance | Excel Worksheet Functions | |||
Running Balance | Excel Discussion (Misc queries) | |||
running balance | New Users to Excel | |||
rent received/balance owed/running balance spreadsheet | Excel Discussion (Misc queries) |