Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Spreadsheet with 2 columns, first has site name, second has time taken to
make a delivery to that site (In decimal) So for instance A1 = London B1 = 2.10 A2 = Birmingham B2 = 4.60 A3 = Edinburgh B3 = 6.70 etc,etc Is it possible to build a formula that will take the data in column B and work out which deliveries will go together to form a working day of no more than 11.00 hours? Mark |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
match formula question | Excel Worksheet Functions | |||
match formula question | Excel Worksheet Functions | |||
Match formula question | Excel Worksheet Functions | |||
Text comparison - closest match | Excel Discussion (Misc queries) | |||
Text string comparison - closest match | Excel Discussion (Misc queries) |