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

Originally Posted by leena1126

just saw your latest reply....still confused.

start on the second row. then copy to the right. yep, it's obvious it's a ctrl-shift-enter formula. thanks for the friendly reminder though.

I apologize for the unintended condescension.

Originally Posted by leena1126

Totally confused since you use both rows here. I'm not sure what to substitute in...also not sure why column A is used.

I'm not sure what you mean. I based this on your attachment. The formula I provided is placed somewhere in row 2, e.g. M2, and then copied to the right.

It can also be copied down to give similar results for the entries in row 3.

Regards