View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
annoni annoni is offline
external usenet poster
 
Posts: 21
Default sort with custom list

To clarify my question...

Is there a way to sort data using two cusom lists...for example

using custom list 1

grape
cherry
melon
apple
pear
tomato

and custom list 2

red
green
yellow

to get result below

grape
cherry
melon
apple_red
apple_green
apple_yellow
pear_red
pear_green
pear_yellow
tomato_red
tomato_green
tomato_yellow


Thanks.