sorting rows

R

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
 
G

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
 
R

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

Gord Dibben said:
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
Click to expand...
 
T

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


Ryan H. said:
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
Click to expand...
 
R

Ryan H.

good idea.. thanks


Tom Ogilvy said:
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.
Click to expand...
 
Top