Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup
Can anyone help with a lookup formula that will look at the cell closes to
6:00, 6:15, 6:30, 6:45, 7:00, etc. and tell me what the number of agents we're (cell to the right) in each interval? There is no pattern, so the lookup value will not always be in the same cell location each day. Date Time Agents Available 11/2/2007 06:12:56 15 11/2/2007 06:14:56 15 11/2/2007 06:15:20 14 11/2/2007 06:15:28 15 11/2/2007 06:15:52 14 11/2/2007 06:16:40 13 11/2/2007 06:22:16 14 11/2/2007 06:23:28 15 11/2/2007 06:23:52 16 11/2/2007 06:24:16 15 11/2/2007 06:24:56 14 11/2/2007 06:25:12 13 11/2/2007 06:25:20 13 11/2/2007 06:25:28 12 11/2/2007 06:28:40 15 11/2/2007 06:29:20 14 11/2/2007 06:30:00 15 11/2/2007 06:30:08 14 11/2/2007 06:30:56 15 11/2/2007 06:31:04 14 11/2/2007 06:32:48 13 11/2/2007 06:44:48 13 11/2/2007 06:44:56 14 11/2/2007 06:45:04 13 11/2/2007 06:45:12 13 11/2/2007 06:45:20 13 11/2/2007 06:45:28 13 11/2/2007 06:45:36 12 11/2/2007 06:45:44 12 11/2/2007 06:45:52 12 11/2/2007 06:59:20 20 11/2/2007 06:59:28 20 11/2/2007 07:00:00 21 11/2/2007 07:00:08 22 11/2/2007 07:00:16 23 11/2/2007 07:00:40 22 11/2/2007 07:01:12 23 11/2/2007 07:02:24 22 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Get Cell Address From Lookup (Alternative to Lookup) | Excel Worksheet Functions | |||
Join 2 Lists - Lookup value in 1 list & use result in 2nd lookup | Excel Worksheet Functions | |||
Sumproduct - Condition based on lookup of a Lookup | Excel Discussion (Misc queries) | |||
Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) | |||
How do I lookup and return different values when the lookup value. | Excel Discussion (Misc queries) |