DigDB      Excel Add-ins      Add-in Tools for Excel Elites
Who else wants to do a 10-hour Excel analysis in 15 minutes? (more ...)

Features | Testimonial | Download free 15-day trial | Purchase | FAQ | Contact

Random Sort, Select

Excel does not have random sorting. But a random sort can be useful. For example, a user asked us how he can randomly select some values from a list. Well, instead of randomly selecting 5 cells, you can randomly sort the list, and pick the top 5 values.
    Random Sort, Select
    Practice file - random-sort-demo.xls (16k)

  1. Click a single cell within your table area. Invoke 'DigDB->Sort->Random'. The table area will be automatically selected

    Random Sort, Select

  2. Click OK to sort.

    Random Sort, Select

  3. Random sort result is:

    Random Sort, Select

  4. Random sort again:

    Random Sort, Select

Need more?


Features | Testimonial | Download | Purchase | FAQ | Contact

Copyright © 1999-2007 All rights reserved

DigDB      Excel Add-ins      Add-in Tools for Excel Elites
Who else wants to do a 10-hour Excel analysis in 15 minutes?

Related keywords: Advanced excel tips, excel questions tools, Excel reporting applications, Excel add-ins add-in, Excel shareware, Excel plugin plug-ins plugins, Excel tricks question, Excel utility utilities, Excel add-on add-ons, Excel tip tips, Power excel technique, Excel manipluation, Excel guru, Excel trick, Excel toolkit, Excel app power user

Microsoft Office Marketplace logo
Microsoft and the Office logo are trademarks or registered trademarks of
Microsoft Corporation in the United States and/or other countries.