sorting rows
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" <gorddibbATshawDOTca wrote in message
...
Ryan
Select ALL the columns you want sorted together.
DataSort 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
On Sun, 01 Aug 2004 22:41:00 GMT, "Ryan H."
wrote:
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
|