Sorting Multiple Columns in Excel 2003

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jason Perilla - 29 Sep 2009 21:21 GMT

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/tutorials/aspnet/8a2ea78b-f1e3-45b4-93ef-32b2d802ae17
/wpf-datagrid-custom-pagin.aspx

Reply to this Message

Jason Perilla - 29 Sep 2009 21:23 GMT

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.

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/tutorials/aspnet/8a2ea78b-f1e3-45b4-93ef-32b2d802ae17
/wpf-datagrid-custom-pagin.aspx

Reply to this Message

Pete_UK - 30 Sep 2009 01:33 GMT

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

> To clarify:
>
[quoted text clipped - 27 lines]
> EggHeadCafe - Software Developer Portal of Choice
> WPF DataGrid Custom Paging and Sortinghttp://www.eggheadcafe.com/tutorials/aspnet/8a2ea78b-f1e3-45b4-93ef-3...

Reply to this Message

Bob I - 29 Sep 2009 21:32 GMT

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

Jason wrote:

> I have this:
>
[quoted text clipped - 19 lines]
> WPF DataGrid Custom Paging and Sorting
> http://www.eggheadcafe.com/tutorials/aspnet/8a2ea78b-f1e3-45b4-93ef-32b2d802ae17
/wpf-datagrid-custom-pagin.aspx

Reply to this Message