How to handle subscriptions

[Exc3l]

Hi guys,

Need your advise here.... Thanks in advance.

I am using excel to record subscriptions paid by customers. Customers pay a year in advance or more.

I managed to formulate the payments into months in columns. And when I need to see whose subscription is due, I just filter the month column that is blank and that would be it.

But I realized that this was not true... because the customer could have made the payment and it is on a separate line... Thus when filtered, it does not show...

I need to show each month how much is the subscription and also whom is due for payment....

Appreciate if someone here could provide a solution...

Thank you.

[JohnTopley]

Please provide a small file (without any confidential data) showing the formatting of your data and the desired results.

Click "Go Advanced" the Paper Clip icon to upload a file