Prev: Macro or VB code to hide and unhide Label box
Next: Macro-save to html
From: Dietrich on 18 May 2010 23:04
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
From: Gord Dibben on 19 May 2010 14:29
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
<Dietrich(a)discussions.microsoft.com> 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.

From: Dietrich on 20 May 2010 16:16
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
> <Dietrich(a)discussions.microsoft.com> 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.
>
> .
>
 | 
Pages: 1
Prev: Macro or VB code to hide and unhide Label box
Next: Macro-save to html