View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
gobonniego gobonniego is offline
external usenet poster
 
Posts: 5
Default Analysis? Who's at bat next? I have no idea what to call this.

I'm trying to make an overtime file for my Fire Department. In it, I will be
keeping track of how many hours of overtime each member has worked. When
it's time to call people and offer them an overtime shift, I need to know who
has the least amount of hours so I can offer it to that firefighter first. I
have a page set up with everyone's name and total OT hours, and I know I can
just sort it to find out who has the least/most. But is there a way for
Excel to do this automatically and possibly pop up the answer of who the
first 5 names off the list of who to call might be?

I certainly have the ability to look up the answer in my Excel book, I just
don't know what to call this type of operation. Can you help me?