Arrange B values ascending order but keep attached to column A in.

  • Thread starter Thread starter Zimba
  • Start date Start date
Z

Zimba

I have two columns of data in XLS, A is the years the data was collected and
B is the data for those years. I want to arrange the numerical data in
column B in ascending order but keep the corresponding years for the data
attached to them.
 
The trick is to select BOTH cols A & B and then sort by B ascending. The
values in col A will stay with the associated values in col B. So if we
start with:

1/22/2010 1
1/23/2010 69
1/24/2010 71
1/25/2010 29
1/26/2010 31
1/27/2010 9
1/28/2010 64
1/29/2010 49

will end up with:

1/22/2010 1
1/27/2010 9
1/25/2010 29
1/26/2010 31
1/29/2010 49
1/28/2010 64
1/23/2010 69
1/24/2010 71
 
Back
Top