A B C 1 ON 1 2 OFF 3 3 ON 4 4 ON 5 OFF 6 OFF 7 OFF 8 OFF 9 OFF 10 OFF
Column A is a list of numbers that are either turned ON or OFF.
Column B indicates whether they are turned ON or OFF. As you can see, numbers 1, 3 and 4 are turned ON.
Column C lists the numbers that are currently turned ON. Can anyone help with a formula for Column C that will list these numbers that are turned ON in a consecutive manner?