Sorting and linking

  • Thread starter Thread starter namelocbob
  • Start date Start date
N

namelocbob

I am trying to make a workbook to determine overtime eligibility. This
is done by low hours receiving lower number for rotation. My problem
is that it has to be listed in order of seniority.and when I try to
sort, only the hours column changes rendering useless the order I need
them in.
Example:
Seniority Name Hours Rotation

1 Bob 1485 2
2 Jim 1484 1
3 Bill 1486 3
 
namelocbob said:
I am trying to make a workbook to determine overtime eligibility. This
is done by low hours receiving lower number for rotation. My problem
is that it has to be listed in order of seniority.and when I try to
sort, only the hours column changes rendering useless the order I need
them in.
Example:
Seniority Name Hours Rotation

1 Bob 1485 2
2 Jim 1484 1
3 Bill 1486 3
Click to expand...

To keep the data in each row together when you sort (which I think is your
problem?), you must either select only one cell in the data area, or select
the entire data area, before doing the sort. If you select just one column,
Excel will sort just that column.
 
Back
Top