Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have a table of data as below. There are more Customers, and more dates'
worth of data, but they won't fit in this window. For a number of our customers, we change delivery routes during the week in order to optimize our shipping capacity. Basically, I am trying to see for each delivery route, on a given day, how many of the same customers are on the same route. In other words, when one customer changes from one route to another over a date range, do other customers switch to the same routes on the same days? Cust # Rt# 8/27/2005 8/29/2005 8/30/2005 8/31/2005 a 1069 a 1081 1 a 1088 a 1090 1 1 a 3271 b 1003 1 b 1076 1 b 1089 1 b 1101 c 1069 c 1071 c 1081 1 c 1082 c 1090 1 d 958 d 1069 d 1070 d 1072 d 1080 1 d 1082 e 1069 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Date & Time | New Users to Excel | |||
Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
Find a Function to use accross different worksheets | Excel Worksheet Functions |