Sorting data with multiple criteria

Hi,

 

I’m trying to figure out the best way to analyze this data. What I have is different loan ID numbers and dates that payments were received a specific way (I have already filtered out all of the payment methods I do not wish to analyze.)

 

What I’m trying to do is to see which of each of these loan numbers have made payments in this specific method multiple months in a row. I have over 3,000 rows of information to work with.

I only care about the loans which have at least 3 consecutive months of payment with this method, and the day of the month it was receieved is also not relevant.

Right now the loan number is in A2 to A3745 and the payment dates are matched up in the B column.

I’m having trouble setting up my formula to include all this information! I’ve been researching for the past 2 hours with no luck, especially with monthly sequential filtering.

By: Sarah

Leave a Reply

Your email address will not be published. Required fields are marked *