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

--
Gary''s Student - gsnu201001


"Zimba" wrote:

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.