Home |
Search |
Today's Posts |
#1
|
|||
|
|||
excel group sorting
Is there a way to group sort. I have a spreadsheet that each group is 4
rows,that must stay together. I need to sort by the 1st date of column 3 (closing date). see example below: Job # Buyer Closing Date SL-2541 John B 01/18/06 1721b/l lot 1o block 4 10/21/05 FL 1622 sw 1st st 01/06 notes SL2182 Jack C 01/05/06 1834/l lot 15 block 7 10/05/05 FL 1894 sw 3rd ln 02/06 notes SL2195 Jane D 12/21/05 1835/l lot 10 block 2 09/30/05 fl 1921 swan ct 01/06 |
#2
|
|||
|
|||
If you want to use Excel's features effectively, you shouldn't have multiple
rows per record. One row per record works best. If you want to get your data into rows, try the "Vertical to Horizontal..." http://www.officearticles.com/excel/...soft_excel.htm ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "meehaha" wrote in message ... Is there a way to group sort. I have a spreadsheet that each group is 4 rows,that must stay together. I need to sort by the 1st date of column 3 (closing date). see example below: Job # Buyer Closing Date SL-2541 John B 01/18/06 1721b/l lot 1o block 4 10/21/05 FL 1622 sw 1st st 01/06 notes SL2182 Jack C 01/05/06 1834/l lot 15 block 7 10/05/05 FL 1894 sw 3rd ln 02/06 notes SL2195 Jane D 12/21/05 1835/l lot 10 block 2 09/30/05 fl 1921 swan ct 01/06 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Excel subtotal group sort | Excel Worksheet Functions | |||
In Excel, sorting columns automatically by clicking column title | Excel Discussion (Misc queries) | |||
Excel 2003 : Group By | Excel Worksheet Functions | |||
how do you group and ungroup rows or columns in new Excel? | Excel Worksheet Functions |