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.
|