Here is a quick formula trick you can use to generate sequence numbers that only increment when there is a change.
Assuming the sequence of values are in column C from C3,
- you can write the following formula in B4 onwards (B3 will be 1, wake up…)
- Now just copy paste the formula over the entire range B2:Bxxx to generate sequence numbers.
How it works?
- That is for your home work for the day 😛
Browse more excel quick tips and learn something cool.