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.
Leave a Reply
|Team To Do Lists – Project Tracking Tools using Excel [Part 2 of 6]||Fix this chart [excel homework #1]|