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