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

  • Thread starter Thread starter BobbyFlanigan
  • Start date Start date
B

BobbyFlanigan

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

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

Stan Scott
New York City
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

List of names that can be divide by catagory in a single step 1
How do i sort contacts using more than one catagory ? 1
Adding contacts to distribution list via catagory 1
Listbox 3
Lost my catagories list when I replaced my laptop 4
custom flag for entire catagory? 1
"scroll to" by list box selection 1
List sorting and macros 3

Back
Top