Formula that only applies at the nth occurrence of a given value

Hey. I have a table with '0' and '1'. This table might be much larger than this, but always filled with '0' and '1'. The conditional formatting works just as a visual aid.

My goal is to replicate this table in another sheet so that every '1' is turned into a '0', except for every 10th '1'. The formula should sweep each row from left to right, starting at the top left corner (B2). In this example it would return the following (red '0' are the cells changed by the formula).

Thank you.

submitted by /u/jmariorebelo to r/excel
[link] [comments]

from upvoted by jmcgready


Popular posts from this blog

High density foam rollers for post workout massage

The Polak Game: an exercise to help reveal your theories of the future