Pending List of Payment

[vv31121985]

HiNinjas
In the attached excel need a seperate list of pending persons who had not done payment under condition if the Dwelling status is Yes & also the number of months they have not made the payment.need a macro to run this and generate a list.If possible a Bar chart to represent the same.

 

[vletm]

Your list will be blank!
Because
#1 if the Dwelling status is Yes
- none Yes.
#2 the number of months they have not made the payment
- there are eight months ... where are payments?

Could You explain other words - what do You really need?

 

[vv31121985]

Your list will be blank!
Because
#1 if the Dwelling status is Yes
- none Yes.
#2 the number of months they have not made the payment
- there are eight months ... where are payments?

Could You explain other words - what do You really need?

Apologies
Dwelling status >> In to be considered

payments i Rs 300 marked to be considered in case if it is blank they have not paid the amount.So those who have not paid 300 will be defaulter.

I am trying to consolidate that a person with Dwelling status as In but not paid , month wise defaulter + how many months they have not paid.

 

[vv31121985]

 

[vletm]

#1 Dwelling status >> In to be considered
There has used four different Dwelling Statues...


#2 There are eight months.
You have marked above ... four months. One has a value.
Other rows has other kind of combinations.

Again:
Could You explain other words - what do You really need?

 

[vv31121985]

#1 Dwelling status >> In to be considered
There has used four different Dwelling Statues...
View attachment 91026

#2 There are eight months.
You have marked above ... four months. One has a value.
Other rows has other kind of combinations.

Again:
Could You explain other words - what do You really need?

hi Ninja thanks for support
Scenario is in our association people reside inside but not paying the monthly subscriptions so want to get the list of people who are residing inside but not paid the subscriptions this is my ask.
So I tried to use combination <Dwelling status -===> in > without paid status to be found out.

 

[vv31121985]

Across months who has paid till now and who has not paid is not able to get as if we appl filter manuall getting this is difficult so need a macro or formula based conditions to arrive the pending payment list + pending names