Sort column with multiple values
 

Is there a way to (data) sort columns so that multiple values are recognized?
I have a column labeled lawsuit type where I classify cases (.i.e. fraud,
discrimination). Some lawsuits fall into multiples categories (both fraud
and discrimination). Right now it's just sorting in alphabetical order and
only recognizes the first word I write in.

Sort column with multiple values
 

Try Data Filter AdvancedFilter, and follow the menus........once set up,
it will allow you to filter on multiple selections in a single
column..........

Vaya con Dios,
Chuck, CABGx3

"gildedlily" wrote in message
...
Is there a way to (data) sort columns so that multiple values are
recognized?
I have a column labeled lawsuit type where I classify cases (.i.e. fraud,
discrimination). Some lawsuits fall into multiples categories (both fraud
and discrimination). Right now it's just sorting in alphabetical order
and
only recognizes the first word I write in.

Sort column with multiple values
 

Thanks for the suggestion. I tried the AdvancedFilter, but couldn't get it
to work. Nothing seems to happen when I click the AdvancedFilter button.
Any more suggestions? Thanks!

"CLR" wrote:

Try Data Filter AdvancedFilter, and follow the menus........once set up,
it will allow you to filter on multiple selections in a single
column..........

Vaya con Dios,
Chuck, CABGx3

"gildedlily" wrote in message
...
Is there a way to (data) sort columns so that multiple values are
recognized?
I have a column labeled lawsuit type where I classify cases (.i.e. fraud,
discrimination). Some lawsuits fall into multiples categories (both fraud
and discrimination). Right now it's just sorting in alphabetical order
and
only recognizes the first word I write in.

Sort column with multiple values
 

Check here for more info on Advanced Filter...........
http://www.contextures.com/xladvfilter01.html
http://www.contextures.com/xladvfilter02.html

Vaya con Dios,
Chuck, CABGx3



"gildedlily" wrote in message
...
Thanks for the suggestion. I tried the AdvancedFilter, but couldn't get
it
to work. Nothing seems to happen when I click the AdvancedFilter button.
Any more suggestions? Thanks!

"CLR" wrote:

Try Data Filter AdvancedFilter, and follow the menus........once set
up,
it will allow you to filter on multiple selections in a single
column..........

Vaya con Dios,
Chuck, CABGx3

"gildedlily" wrote in message
...
Is there a way to (data) sort columns so that multiple values are
recognized?
I have a column labeled lawsuit type where I classify cases (.i.e.
fraud,
discrimination). Some lawsuits fall into multiples categories (both
fraud
and discrimination). Right now it's just sorting in alphabetical
order
and
only recognizes the first word I write in.