Can you sort a list based on catagory names without useing a custom list?
 

Can you sort a list based on catagory names without useing a custom
list?

Thanks,
Bobby

Can you sort a list based on catagory names without useing a custom list?
 

Without a custom list, you can only sort the names alphabetically, ascending
or descending.

Stan Scott
New York City

"BobbyFlanigan" wrote in message
...
Can you sort a list based on catagory names without useing a custom
list?

Thanks,
Bobby

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