I have a document that contains 1000+ addresses. How can I program excel to identify each address and assign it to a particular route? This route would be based on a particular area and driver.
I have a document that contains 1000+ addresses. How can I program excel to identify each address and assign it to a particular route? This route would be based on a particular area and driver.
Hi Akela928. Welcome to the forum.
To best describe or illustrate your problem you would be better off attaching a “dummy” workbook
without sensitive data. The workbook should contain the same structure and some dummy data of the
same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this
format abc-123 then that should be reflected in the dummy workbook.
To attach a file to your post,
click “Go Advanced” (next to quick post),
scroll down until you see “Manage Attachments”,
click that and select “Add Files” (top right corner).
click on “Browse”
select your file(s)
click “Open” click “Upload” click “Done” (bottom right)
click “Submit Reply”
Once the upload is completed the file name will appear at the bottom of the reply editor window.
Last edited by FlameRetired; 06-14-2015 at 06:22 PM.
Dave
Sorry it took so long, had a more pressing problem to deal with. Anyways attached is the file. What I need to do is assign a route number from 1-16 in column 'D' based on the street name from column 'A'. I will then need to assign a driver name based on a separate tab listing the route numbers and drivers. There will be hundreds of street names daily. However once I have the formula in place the street names for each day will not change. Hopefully this can be done in excel.
We're going to need more information. For example what are the connections between street names and route #s? Perhaps another lookup table? Without that we are left to guess.
I've proposed a lookup table example in Drivers sheet. With that you can do this formula in D2:D17 of Main sheet.and from there this formula in E2:E17 of Main sheet.Formula:Please Login or Register to view this content.The reworked file is attached.Formula:Please Login or Register to view this content.
Picture if you will an area of a city divided into 4 quadrants, within those four quadrants you can have as many as 15 routes. Each route is assigned to a different driver. The data collected on the master sheet is a list of the Service requests or customer call in complaints for a particular address. What I need to do is look at the address in the one cell, determine which route it belongs to and then assign that complaint to the driver responsible for that route. Hopefully this clears up some of your questions.
Can you tell us which quadrant each of those addresses is in?
Can you then tell us which of those 15 routes each address is assigned to?
Without that information Excel will have to read our minds. It won't do that.
I'm confident we can make short work of this if you can provide specific examples in a workbook ... not just general descriptions. It helps us to help you. This means that the bulk of the work is going to fall on you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks