Can you sort a list based on catagory names without useing a custom list? Thanks, Bobby
B BobbyFlanigan Jul 29, 2004 #1 Can you sort a list based on catagory names without useing a custom list? Thanks, Bobby
S Stan Scott Jul 29, 2004 #2 Without a custom list, you can only sort the names alphabetically, ascending or descending. Stan Scott New York City
Without a custom list, you can only sort the names alphabetically, ascending or descending. Stan Scott New York City
D Dave Peterson Jul 29, 2004 #3 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.
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.
