Sorting Multiple Columns in Excel 2003

[Jason Perilla]

I have this:

1
4
3
5
8
6

I want this:

1
3
4
5
6
8

Any Ideas? This is in Excel 2003.

EggHeadCafe - Software Developer Portal of Choice
WPF DataGrid Custom Paging and Sorting
http://www.eggheadcafe.com/tutorial...f-32b2d802ae17/wpf-datagrid-custom-pagin.aspx

 

[Jason Perilla]

To clarify:

I have two colums. Each has some blanks and some numbers.

I want the two colums sorted ascending taking into consideration the numbers in both and relative to both.



Jason Perilla wrote:

Sorting Multiple Columns in Excel 2003
29-Sep-09

I have this:

1
4
3
5
8
6

I want this:

1
3
4
5
6
8

Any Ideas? This is in Excel 2003.

EggHeadCafe - Software Developer Portal of Choice
WPF DataGrid Custom Paging and Sorting
http://www.eggheadcafe.com/tutorial...f-32b2d802ae17/wpf-datagrid-custom-pagin.aspx

 

[Bob I]

Simple way is use a third column with =Max(a1,b1) and sort on that.

 

[Pete_UK]

You could use a helper column and join those two columns together,
e.g. put this in C1:

=A1&B1

and copy down. Include the helper column within the range to be
sorted, and sort on the helper column. Then you can remove it.

Hope this helps.

Pete