| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting information in columms
Hi,
I have a worsheet which includes the following columms: organization name/ donation a/ solicitor. I would like the spreadsheet to be organized as follows: 1) Names of organizations that have an appointed solicitor. 2) Names of organizations that don't have an appointed solicitor sorted alphabetically. I know how to view these two seperate items individually, but how do I include all of this on one spreadsheet as opposed to saving two copies of the spreading with the seperate sorting requirements. Your help would be greatly appreciated. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sorting information in columms
Try to have just one block of data then either filtering the data or using a
pivot table. Hilight the top row with the headings and click, data--filter--autofilter "femfrog" wrote: Hi, I have a worsheet which includes the following columms: organization name/ donation a/ solicitor. I would like the spreadsheet to be organized as follows: 1) Names of organizations that have an appointed solicitor. 2) Names of organizations that don't have an appointed solicitor sorted alphabetically. I know how to view these two seperate items individually, but how do I include all of this on one spreadsheet as opposed to saving two copies of the spreading with the seperate sorting requirements. Your help would be greatly appreciated. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sorting information in columms
It's already on Autofilter
"akphidelt" wrote: Try to have just one block of data then either filtering the data or using a pivot table. Hilight the top row with the headings and click, data--filter--autofilter "femfrog" wrote: Hi, I have a worsheet which includes the following columms: organization name/ donation a/ solicitor. I would like the spreadsheet to be organized as follows: 1) Names of organizations that have an appointed solicitor. 2) Names of organizations that don't have an appointed solicitor sorted alphabetically. I know how to view these two seperate items individually, but how do I include all of this on one spreadsheet as opposed to saving two copies of the spreading with the seperate sorting requirements. Your help would be greatly appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sorting a column of information | Excel Discussion (Misc queries) | |||
| How do I covert rows to columms? | Excel Worksheet Functions | |||
| Rows into Columms | Excel Worksheet Functions | |||
| Sorting information into lists | Excel Discussion (Misc queries) | |||
| formula help, sorting information | Excel Worksheet Functions | |||
Linear Mode
