Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display 3 Minimum Time slots
I Have Data as Follows
A B C D E Time 1st 2nd 3rd 4th 7:00 0 1 7:10 0 0 7:20 1 2 7:30 4 1 7:40 3 3 7:50 8 9 8:00 10 11 8:10 8 5 8:20 15 11 Etc 7:00, 7:10, 7:20 etc are clock time and 0 , 1 , 4 etc are No of Employees who ented the gate. I want to find out the 3 Clock time for each day where min Employees has entered the gate for each day. want to Insert a Formula Below each Column. Eg Sol. for Data Above (3 Least busy time Slots) A B C 7:00 7:10 7:10 7:00 7:20 7:30 Basically I want to Know for each day, 3 Slots of time where entry in minimum. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to lookup the minimum, 2nd minimum and 3rd minimum......... | Excel Worksheet Functions | |||
Time display | Excel Discussion (Misc queries) | |||
Time Display ? | Excel Worksheet Functions | |||
Formula for placings, using 4 times and greater than minimum time | Excel Worksheet Functions | |||
counting time slots | Excel Worksheet Functions |