Hep filling column with a number sequence whenever value changes
Hello, I am trying to fill a column with a number series starting with 1 whenever a value changes in the adjacent column. So for instance I am trying to do something like this :
87 1
87 2
87 3
88 1
88 2
88 3
88 4
89 1
89 2
90 1
91 2
92 1
92 2
92 3
92 4
92 5
92 6
Any help would be greatly appreciated, thanks!
Or see example workbook formula B2
Please Login or Register to view this content.
I forgot to mention the data would have to start in row two for this formula to work.
Last edited by Jack7774; 04-28-2014 at 05:44 PM. Reason: additonal information needed
Thank those who have helped you by clicking the Star * below their name and please mark your post [SOLVED] if it has been answered satisfactorily.
Did this work for you?
If this brought you the desired solution please give rep to those involved and mark thread as solved.
And if the numbers not following, you can use this one.
=countif($G$2:$G2,$G2)
See the attached file.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Very nice! I learned something new.Originally Posted by oeldere
@jessebranum777
Glad to help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks