Where is "Sort On: Values" option?..cannot find it.


"Ron Rosenfeld" wrote:

On Fri, 13 Jun 2008 08:21:02 -0700, annoni
wrote:

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.

Yes.

Assume your data is in A2:A13

Enter the following formulas:

B2: =LEFT(A2,FIND("_",A2&"_")-1)
C2: =MID(A2,1+FIND("_",A2&"_"),63)

Fill B2:C2 down to row 13.

Select some cell in the table, or A2:C13

Data/Sort
Sort by: Column B
Sort On: Values
Order: Custom list = grape, cherry, etc.

Sort by: Column A
Sort On: Vaues
Order: Custom List = red, green, yellow

Hide columnns B&C
--ron