View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
claude jerry claude jerry is offline
external usenet poster
 
Posts: 70
Default 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