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

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.
 
G

Gary''s Student

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to use/create code in MS Word to calculate age? 0
Change a great number of words in word files, with a macro as short as possible. 5
Create a chart from a table in word thats dynamic 0
Place numbers in ascending order 2
Setting language of a selected text in Office apps. 0
Summing rows using formulas with variables 2
ISO best steps to export (import) all from Outlook 2003 to Outlook in MS 365 0
Two columns followed by single page-width column on same page 0

Top