Sort data based on hours in column.

  • Thread starter Thread starter Paul Tuttle Sr,
  • Start date Start date
P

Paul Tuttle Sr,

I have an excel spread sheet that has my employees names and overtime
hours listed for each. The hours change for each pay period. The
hours are manually entered for each. I need a way that when the hours
are entered it moves the employee with the lowest amount of overtime
time to the top of the list. This would mean lowest to highest on
overtime. This would be in keeping with our union contract of offering
overtime to the lowest then on to the next highest and so on.

Could this be done? If so how hard would it be?
 
Paul,

After you enter the hours manually, select a single cell in your table, and then use Data sort, and
choose Ascending based on the column of overtime. OR select a cell in your overtime column and
click the Ascending button on the standard toolbar, if it is showing.

HTH,
Bernie
MS Excel MVP
 
Back
Top