Create a number sequence for each change in a column in excel [Quick Tip]
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.
My name is Chandoo. Thanks for dropping by. My mission is to make you awesome in Excel & your work. I live in Wellington, New Zealand. When I am not F9ing my formulas, I cycle, cook or play lego with my kids. Know more about me.
Thank you and see you around.
Leave a Reply
|« Team To Do Lists – Project Tracking Tools using Excel [Part 2 of 6]||Fix this chart [excel homework #1] »|