Sort column with multiple values

[gildedlily]

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.

 

[CLR]

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]

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]

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