Sorting information in columms

  • Thread starter Thread starter femfrog
  • Start date Start date
F

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.
 
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
 
It's already on Autofilter

akphidelt said:
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
Click to expand...
 
Back
Top