Hi Experts
Need some assistance with a task. I have several delivery routes that have various number of stops on each. What I need to do is to determine the number of stops per route, divide it by 4 and then assign an alpha letter to each segment. All of our delivery routes have a different number of stops so that is not static. Below is a very simple idea of what I am trying to do. One column is the stop number and the next is the segment letter (sorry the alpha didn't line-up under the word "segment".
Any help would be greatly appreciated.
VALUE SEGMENT
1 A
2 A
3 A
4 B
5 B
6 B
7 C
8 C
9 C
10 D
11 D
12 D
Our community of experts have been thoroughly vetted for their expertise and industry experience.