sorting rows

[Ryan H.]

Hi,

I have a column that contains dates, and adjacent columns that contain data.

How can I sort the rows with respect to the dates?

Thanks

 

[Gord Dibben]

Ryan

Select ALL the columns you want sorted together.

Data>Sort> select your date column and ascending or descending.

If you need some other sort criteria such as by month or year post back with
details.

Gord Dibben Excel MVP

 

[scrabtree]

http://www.j-walk.com/ss/excel/tips/tip74.htm

You may be able to modify these techniques for your use.

 

[Ryan H.]

Im sorry.. I forgot to say something...

The data is in this format:

jan 13 904
mar 9 245
feb 2 593
jun 5 25
jan 5 79

I have 4 columns, in which 2 of them are dates... by the way, im writing a
macro and cannot do the Data-Sort..etc..

I want them sorted this way:

jan 5 79
jan 13 904
feb 2 593
mar 9 245
jun 5 25


Thanks

Ryan

Select ALL the columns you want sorted together.

Data>Sort> select your date column and ascending or descending.

If you need some other sort criteria such as by month or year post back with
details.

Gord Dibben Excel MVP

 

[Tom Ogilvy]

the obvious solution is to use a 5th column on the right, have it pick up
the dates in each row, then sort on this column. This would be done either
manually or using code.

--
Regards,
Tom Ogilvy

Im sorry.. I forgot to say something...

The data is in this format:

jan 13 904
mar 9 245
feb 2 593
jun 5 25
jan 5 79

I have 4 columns, in which 2 of them are dates... by the way, im writing a
macro and cannot do the Data-Sort..etc..

I want them sorted this way:

jan 5 79
jan 13 904
feb 2 593
mar 9 245
jun 5 25


Thanks

 

[Ryan H.]

good idea.. thanks

the obvious solution is to use a 5th column on the right, have it pick up
the dates in each row, then sort on this column. This would be done either
manually or using code.