Sorting Multiple Columns in Excel 2003

  • Thread starter Thread starter Jason Perilla
  • Start date Start date
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
 
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
 
Back
Top