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?
|