Sorting information in columms

[femfrog]

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.

 

[akphidelt]

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]

It's already on Autofilter

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