| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| Lookup values in one column to return another | Excel Worksheet Functions | |||
| How to get the values using a condition refering to the other column | Excel Worksheet Functions | |||
| creating a bar graph | Excel Discussion (Misc queries) | |||
| How sum values in column B using values in column A as the conditi | Excel Worksheet Functions | |||
Linear Mode
