ferocious12
Member
Dear All,
Can you help me with a formula that calculate current month addition or deletion of number of housing units based on Type (it can be sold more or some of them can be cancelled resulting in reduction in number of units sold). The problem is Types of units keep changing each month say Villa A & Villa B in April but in May it can Villa A and Villa D.
I have attached an example with desired result.
Thanks
Can you help me with a formula that calculate current month addition or deletion of number of housing units based on Type (it can be sold more or some of them can be cancelled resulting in reduction in number of units sold). The problem is Types of units keep changing each month say Villa A & Villa B in April but in May it can Villa A and Villa D.
I have attached an example with desired result.
Thanks