| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sort by groups in excel
I have a very large wkst in which I need to creat sub-total type cells but by
date. I then need to sort these sub-cells without losing the original line information. Any ideas? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
sort by groups in excel
Stacey,
Without knowing what the data looks like, I would probably use a PivotTable. If you need to "group" your date, (by month, year, etc.) check out Debra Dalgleish's site he http://www.contextures.com/xlPivot07.html HTH "staceyc" wrote: I have a very large wkst in which I need to creat sub-total type cells but by date. I then need to sort these sub-cells without losing the original line information. Any ideas? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
sort by groups in excel
Thanks for the link.. I appreciate the help.
"Dominic" wrote: Stacey, Without knowing what the data looks like, I would probably use a PivotTable. If you need to "group" your date, (by month, year, etc.) check out Debra Dalgleish's site he http://www.contextures.com/xlPivot07.html HTH "staceyc" wrote: I have a very large wkst in which I need to creat sub-total type cells but by date. I then need to sort these sub-cells without losing the original line information. Any ideas? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
sort by groups in excel
You're welcome.
"staceyc" wrote: Thanks for the link.. I appreciate the help. "Dominic" wrote: Stacey, Without knowing what the data looks like, I would probably use a PivotTable. If you need to "group" your date, (by month, year, etc.) check out Debra Dalgleish's site he http://www.contextures.com/xlPivot07.html HTH "staceyc" wrote: I have a very large wkst in which I need to creat sub-total type cells but by date. I then need to sort these sub-cells without losing the original line information. Any ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I sort letters before numbers in Excel? | Excel Discussion (Misc queries) | |||
| Sort Ascending button - Excel 2003 | Excel Discussion (Misc queries) | |||
| Formula Integrity Not Preserved During Sort in Excel 2000 | Excel Discussion (Misc queries) | |||
| How do I sort for the maximum values in each year in excel? | Excel Discussion (Misc queries) | |||
| Excel Sort function should not sort the cell formatting! | Excel Worksheet Functions | |||
Hybrid Mode
