Need Sorting Help

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

still learning - 31 May 2005 21:21 GMT

How do you associate adjacent cells in two columns so that when you sort
column B the value of the cell in column A follows the cell in column B?

Signature

still learning

Reply to this Message

Ron Coderre - 31 May 2005 21:27 GMT

Start by including the column A cells with the Column B cells. Then
sort by column B.

Example: if the data is in A2:B10, select that range...then sort by co
B.

Does that help?

Ro

Reply to this Message

still learning - 31 May 2005 21:39 GMT

I'll try that... thanks

Reply to this Message

still learning - 31 May 2005 21:50 GMT

I was hoping that I explained myself clearly, I have a numbers in cells
A1:A12 and different numbers in B1:B12. I want to sort column B in
ascending order and have the numbers from column A stay with the
sorted cells. Please be specific with your direction as "I'm still
learning". Thanks!

Signature

still learning

Reply to this Message

Ron Coderre - 31 May 2005 23:56 GMT

1)Select cells A1:B12.
2)Data>Sort
No header row
Sort by: Column B, Ascending
Click the [OK] button.

That will sort the items in column B and any items in Column A will
sort with their associated partners in Column B.

Does that work?

Ron

Signature

Ron Coderre

Reply to this Message

still learning - 01 Jun 2005 13:15 GMT

Ron, thank you for your help. Your direction was clear and accurate

Reply to this Message