Start and End Date Query

[Dave350z]

Hi,
I've attached a sample of something I'm working on and the layout it's currently in.

I have a list of customers and an amount per month, in the sample, I want to be able to use a formula that will select which month the customer first has an amount >0 and in the end date column, I want to see when the customer then stopped showing an amount >0.

I have a massive list of these customers and sorting them each month is a pain in the a$$.

Any help is appreciated!

DaveStart and End Month Sample.xlsx

[RobertMika]

Copy of Start and End Month Sample.xlsx
Please see attached

[Dave350z]

Great, thanks!