Sorting Data

[crich1187]

Version: 2008 Operating System: Mac OS X 10.5 (Leopard) I would like to sort one column(named A) from smallest to largest and use it as a reference point of sorts and sort the rest of the columns according to their original position in relation to the reference column(A).

 

[Carl Witthoft]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)

I would like to sort one column(named A) from smallest to largest and use it
as a reference point of sorts and sort the rest of the columns according to
their original position in relation to the reference column(A).

What you ask is unclear. Can you post a small example -- like

A B C
5 8 7
1 4 9
2 9 3


Do you want to sort the entire database, i.e. sort the rows by A?
And once you have something like

A B C
1 4 9
2 9 3
5 8 7

what exactly would you like to do to columns B and C?

 

[crich1187]

A B C
1 z @
3 d !
4 g #
2 e $
0 l &
5 q *

I would like to order column A from smallest to largest so that 0 is first and 5 is last. Then I would like columns B and C to be sorted so that z(from column B) is next to 1 (from column A) and * (from column C) is still in the same row as 5. This is what I would like the finished product to look like.

A B C
0 l &
1 z @
2 e $
3 d !
4 g #
5 q *

 

[Mike Middleton]

crich1187 -

Assuming your data are in A1:C6 and column D is empty and row 7 is empty, select any cell in the range A1:C6, choose Data | Sort, No header row, Sort by Column A, Ascending, OK.

- Mike
http://www.MikeMiddleton.com


A B C
1 z @
3 d !
4 g #
2 e $
0 l &
5 q *

I would like to order column A from smallest to largest so that 0 is first and 5 is last. Then I would like columns B and C to be sorted so that z(from column B) is next to 1 (from column A) and * (from column C) is still in the same row as 5. This is what I would like the finished product to look like.

A B C
0 l &
1 z @
2 e $
3 d !
4 g #
5 q *

 

[CyberTaz]

Select a cell in column A of the data range then click the A-Z Sort button
on the Standard Toolbar. See other Sort options in Excel Help.

HTH |:>)
Bob Jones
[MVP] Office:Mac