Sort column with multiple values

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

gildedlily - 24 May 2006 22:53 GMT

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.

Reply to this Message

CLR - 25 May 2006 01:54 GMT

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

> 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.

Reply to this Message

gildedlily - 26 May 2006 18:38 GMT

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!

> Try Data > Filter > AdvancedFilter, and follow the menus........once set up,
> it will allow you to filter on multiple selections in a single
[quoted text clipped - 10 lines]
> and
> > only recognizes the first word I write in.

Reply to this Message

CLR - 26 May 2006 21:48 GMT

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

> 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.
[quoted text clipped - 14 lines]
> > and
> > > only recognizes the first word I write in.

Reply to this Message