I am trying to have the last or largest number return me the destination city?
In the following set, Fort Worth is attached to H382826-4. I am needing Fort Worth to be next to H382826-1. I have already done the Origin part but that was easy. This has me a bit stumped.
Any advise would be greatly appreciated.
H382826-1
H382826-2
H382826-3
H382826-4
I would need something that can look for and up to 8 - 10 stops. Each one of the numbers past the " - " is a dispatch to another driver.
Capture.JPG
Try this in C1 and fill down.
=IF(--RIGHT(A1,1)>1,"",LOOKUP(2,1/(LEFT($A$1:$A$12,7)=LEFT(A1,7)),$B$1:$B$12))
If this doesn't do what you want please upload an Excel workbook. Screenshots aren't of much help and we don't have to re-type the data.
You'll also get more and faster response.
Dave
I agree with Dave. An attached file also gives us a chance to test out the formulas and macros.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks