filter sort

3wits
3wits used Ask the Experts™
on
Assume your column has the following (100, 90, 75, 50, 25, 10, FB, L).  It has multiples of each.

I want to sort using a filter from largest to smallest.  However, I want the FB and L to be after the numbers instead of before.  

Is this possible.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2008
Commented:
You can add a column with the following formula:
=TEXT(A2,"0")
and sort on that.

Or you can create a custom list (copy paste your list) and use that for your sort, as in the attached screencast

Thomas


nutsch-486678.flv

Commented:
use Custom Sort->Order->Custom List -> 100, 90, 75, 50, 25, 10, FB, L

Author

Commented:
I liked the 2nd way because I will be inserting this in a macro.

Thanks

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial