Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Custom sorting
Hello - synopsis - worksheet with 5225 rows and 13 columns - contains dept
numbers and detailed monthly expenses for each dept. I only need info for 20 depts which equals about 500 rows. I've been sorting by Dept number then deleting the depts I do not need ; then creating a pivot table . Problem . Since my dept nos are not in numberical order so I still have to go thru the list to delete the ones I do use. Is there a way to extract the department nos I do use instead or deleting the ones I do not use or another faster way to do complete this task. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom Sorting | Excel Discussion (Misc queries) | |||
Custom Sorting | Excel Discussion (Misc queries) | |||
Need help with custom sorting | Excel Discussion (Misc queries) | |||
Custom auto-sorting...possible? | New Users to Excel | |||
custom sorting | Excel Discussion (Misc queries) |