Deleting consecutive values only if they exceed a certain number of occurrences

I'm working with a large spreadsheet. It consists of physical activity values, ranging from 0 to several thousand per minute.
My task is to delete values of 'non-wear time', which means deleting consecutive values of 10 or more "0's". But not if there is 9 or less. Is there any function or macro that can do this automatically?

I've added a photo as an example, showing a marking of cells that are to be deleted, while underneath there are cells that should not be deleted. Any help on the matter would save me a ton of hours.

example.png

You can try this on a copy of your workbook.

Please Login or Register  to view this content.

This might be better.

Please Login or Register  to view this content.

Hi

Thanks for the replies. I’m still having difficulties with the proposed methods, and they are too advanced for me to successfully debug (I’ve tried )

So I will simplify the problem. In a single column of numbers, I need 10 or more consecutive 0’-s deleted. I’ve added two pictures showing before and after.

It would be preferable if this operation could be performed on the selected cells only, but not crucial.

1.png2.png

How about

Please Login or Register  to view this content.

Perfect! The rest I can handle myself. Thanks a lot

Glad to help 7 thanks for the feedback