| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can you sort a list based on catagory names without useing a customlist?
How about a table of names to category.
Then a helper column that returns the category: Say Sheet2!a:b held the table. =vlookup(a1,sheet2!a:b,2,false) and drag down. Then sort by this column. BobbyFlanigan wrote: Can you sort a list based on catagory names without useing a custom list? Thanks, Bobby -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sort list of names | Excel Discussion (Misc queries) | |||
| How do I sort a list of names | Excel Discussion (Misc queries) | |||
| I'm useing Excel I have a list of names that I need alphabetical | Excel Worksheet Functions | |||
| List of names sort | Excel Discussion (Misc queries) | |||
| Excel sort by Fill Color by custom list sort | Excel Discussion (Misc queries) | |||
![Dave Peterson[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
