Sorting Text in Excel using Formulas

Sorting text is such a day to day activity that it always surprises me why Excel hasn’t provided a simple spreadsheet formula for doing it. Of course you can use the sorting menu command (menu > data > sort) but this requires manual steps (or VBA). Most of the times we get raw textual data [...]

Sorting a list of items in random order in excel - using formulas

In shuffling a list of items in excel I have described the technique of using random numbers generated by RAND() to sort a list of items. The technique had one disadvantage though, every time you need to reshuffle the list you have to press F9 to recalculate the rand() and then go to menu > [...]

Shuffle a list of numbers / items in excel spreadsheet

Here is a quick Monday tip for data junkies.

If you want to shuffle a list of numbers or cells in excel in random order you can do that with “data > sort” menu option of excel.

First insert a column next to the list you want to shuffle and enter random numbers in each [...]

Changing Sort Orientation in Excel - Sorting across columns instead of rows

change-sort-orientation-excel-columns

You can sort data across columns instead of rows by changing sort options. If you ever had to sort across columns now you know a simple way to do this
Follow these steps for changing sort orientation:

Select the table you want to sort (just the data, not the headers as when you change sort [...]