danovkos
10-28-2010, 01:33 AM
Hi,
pls. is it possible do this with formula without VBA code?
I have 2 tables (months) with clients. Both tables have 2 columns. Column with ID and second with amount (e.g. 1000 clients).
First table is january and second february.
In both are the same clients but in february may some of clients from january missing.
I want one number/formula, which sumarize amount of missing clients (They are in jan, but not in febr.). It return their sumarized amount from jan.
Is it possible to do with formula?
If yes, how please?
thx for all advise
pls. is it possible do this with formula without VBA code?
I have 2 tables (months) with clients. Both tables have 2 columns. Column with ID and second with amount (e.g. 1000 clients).
First table is january and second february.
In both are the same clients but in february may some of clients from january missing.
I want one number/formula, which sumarize amount of missing clients (They are in jan, but not in febr.). It return their sumarized amount from jan.
Is it possible to do with formula?
If yes, how please?
thx for all advise