Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

Sort data in excel

Oct 7, 2005 9:18AM PDT

If I have the following excel sheet, 2 columns and want to sort the sheet by date from jan to dec. How would I do this?

Loc Descr Birthdate

Phoenix, AZ 12/05/37
Denver, CO 04/28/39
Louisville, KY 02/01/40
Wauwatosa, WI 07/09/40
Austell, GA 07/26/40

Thanks, J.R.

Discussion is locked

- Collapse -
Click on Data
Oct 7, 2005 12:30PM PDT

then SORT. Then choose the column where the dates are. And then click on ascending.

PS: All the datas those need to be sorted together need to be highlighted so they can move with the dates.

- Collapse -
Re: sorting in Excel
Oct 7, 2005 6:43PM PDT

To sort on month only, as you ask, make a third column with the month from the date (using the month-function) and sort on that. Really easy.

Kees