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).
from upvoted by jmcgready https://ift.tt/2EyHg6l