Hi there – Cannot figure this out. I have a list of items in a column as follows:

5″ White

5″ Red

5″ Blue

11″ White

11″ Red

11″ Blue

17″ White

17″ Red

17″ Blue

There are several more sizes but I need to sort this sheet so that the colors fall in order and the sizes order as 11, 17, 5. 

11″ White

17″ White

5″ White

11″ Red

17″ Red

5″ Red

And so on. The colors are in a specific order not based on alphabet.

Thank you in advance!

​Hi there – Cannot figure this out. I have a list of items in a column as follows:5″ White5″ Red5″ Blue11″ White11″ Red11″ Blue17″ White17″ Red17″ BlueThere are several more sizes but I need to sort this sheet so that the colors fall in order and the sizes order as 11, 17, 5.  11″ White17″ White5″ White11″ Red17″ Red5″ RedAnd so on. The colors are in a specific order not based on alphabet.Thank you in advance!   Read More

​