I have a data set with multiple repeated values such as this
ADA
ADA
ADA
Benton
Canyon
Canyon
Dearborn
Dearborn
Dearborn
Dearborn
and I want to increment a count every time the preceding value is different than the next value.
so my 'count' would be like
1 - ADA
1 ADA
1 - ADA
2 - Benton
3 - Canyon
3 - Canyon
4 - Dearborn
4 - Dearborn
4 - Dearborn
4 - Dearborn
Best answer by bwn
View original