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.

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" <[email protected]> wrote in message
news:[email protected]...
> 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.

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" <[email protected]> wrote in message
> news:[email protected]...
> > 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.
>
>
>

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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> > news:[email protected]...
> > > 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.
> >
> >
> >