Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.
Course Of The Month
3 days, 5 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Determine number of rows and assign name to each.
Posted on 2016-08-22
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
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
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
5-
5
11 Comments
Can you provide with an example of stops and routes and expected result?
A countif or sumif or something like that could work if we get the logic :)
A countif or sumif or something like that could work if we get the logic :)
Active today
See attached.
Will this be done separately for each delivery route or will there also be a route identifier in the list?
Thanks
Rob H
Stops.xlsx
Will this be done separately for each delivery route or will there also be a route identifier in the list?
Thanks
Rob H
Stops.xlsx
Active today
I hadn't refreshed, your last comment answers my question; ignore my comment for now, I will update it.
Thanks
Rob H
Thanks
Rob H
Active today
See updated version attached. All but one are the same as your manually entered values.
Route 3 only has 9 stops which does not divide wholly by 4. My version creates a fifth segment for this because each other segment has two entries.
Thanks
Rob H
Stops.xlsx
Route 3 only has 9 stops which does not divide wholly by 4. My version creates a fifth segment for this because each other segment has two entries.
Thanks
Rob H
Stops.xlsx
Active today
Works perfectly for what I need it for. Thank you so much for your quick and spot-on response.
Andy
Andy
Active today
Glad to be of assistance.
For cases like Route 3 where it doesn't divide wholly by 4; if you want the last stop to be no more than D then adjust the formula to:
=IF(A2<>A1,"A",IF(MOD(B1,F
If you need any explanation for the formula, please let me know.
Thanks
Rob H
For cases like Route 3 where it doesn't divide wholly by 4; if you want the last stop to be no more than D then adjust the formula to:
=IF(A2<>A1,"A",IF(MOD(B1,F
If you need any explanation for the formula, please let me know.
Thanks
Rob H
Active today
Hi Rob
Something came up that I didn't think about before...what if the route has fewer than 4 stops. We have a handful of routes that have 2 or 3 stops only. With your formula it is giving us a #div/0 error.
Any ideas??
Andy
Something came up that I didn't think about before...what if the route has fewer than 4 stops. We have a handful of routes that have 2 or 3 stops only. With your formula it is giving us a #div/0 error.
Any ideas??
Andy
Featured Post
We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Do you use a spreadsheet like Microsoft's Excel? Have you ever wanted to link out to a non excel file on your computer or network drive? This is the way I found to do it!
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
Suggested Courses
Course of the Month3 days, 5 hours left to enroll
695 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.