You can do this too
Download now, it's easy
ASAP Utilities menu
Language:
Range » Advanced sorting...
This tool extends the options to sort your data.You can sort on up to 5 columns at once. Furthermore you can sort on many more properties than just the cell values.
With this tool you can sort by:
- Value
- Number format
- Cell Color
- Cell Color Indexnumber
- Font Color
- Font Color Indexnumber.
- Font Size
- Font Name
- Bold
- Italic
- Underline
- Strikethrough
- Text Length
- Random order (shuffle)
- Formula
- Email address host (@...)
- Alphanumeric content based on the numeric portions
- Year-Month-Day
- Year-Day-Month
- Month-Day-Year
- Month-Year-Day
- Day-Year-Month
- Day-Month-Year
- Day of the week (start on Sunday)
- Day of the week (start on Monday)
Video example
Screenshots
Example screenshot: Sorting with advanced possibilities
Starting this utility
In the Excel menu choose ASAP Utilities » Range » Advanced sorting...Additional keywords:
Colors, Order, Random, Randomise, Colour, e-mail, e-mail address, colours, sort by fill color, sort rows, change order, highlighted color, join colors together, background color
Colors, Order, Random, Randomise, Colour, e-mail, e-mail address, colours, sort by fill color, sort rows, change order, highlighted color, join colors together, background color
« Return to the list of “Range” utilities.
© 1999-2010 - Bastien Mensink - ASAP Utilities - Excel tools - A Must in Every Office BV - The Netherlands 