How do I isolate part of an array (trying to isolate non-zero consecutive values)

Originally Posted by leena1126

You're amazing!

Ok second question....in the next column, how can I get the next month start of a consecutive array. The result I would get for the first array would not be applicable, but for the second array I would get January.

Is this only ever going to be required for the first and second largest streaks? Or are you potentially going to be wanting to extend this for any number of streaks?

Regards