| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I sort data in multiple columns by date in one column?
My spreadsheet has 8 columns: vendor name, invoice date, invoice number
description of rented equipment, rental period-2 columns-"from" & "to", invoice amount and cumulative invoice amount. I want to sort the data by the invoice date in ascending order (from earliest date to latest date). Neither my Excel "Help" books or "HELP" in the toolbar have helped. Please help. Thank You and Happy New Year. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I sort data in multiple columns by date in one column?
Pre-select all 8 columns then DataSort
Sort on the Invoice Date column in ascending order. Gord Dibben MS Excel MVP On Tue, 1 Jan 2008 10:38:06 -0800, sammie wrote: My spreadsheet has 8 columns: vendor name, invoice date, invoice number description of rented equipment, rental period-2 columns-"from" & "to", invoice amount and cumulative invoice amount. I want to sort the data by the invoice date in ascending order (from earliest date to latest date). Neither my Excel "Help" books or "HELP" in the toolbar have helped. Please help. Thank You and Happy New Year. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combine data in two columns into one and sort the combined column alphabetically..how?? | Excel Discussion (Misc queries) | |||
| Can I enter/sort multiple data within cells of a column? | Excel Discussion (Misc queries) | |||
| How can I combine multiple columns of data into 1 column? | New Users to Excel | |||
| Sort multiple rows by data in certain columns | Excel Discussion (Misc queries) | |||
| sort column data with hidden columns - excel 2003 | Excel Discussion (Misc queries) | |||
Linear Mode
