fbpx
Search
Close this search box.

All articles with 'sorting' Tag

How to Round and Sort Data using Excel Formulas?

Published on Jul 6, 2009 in Excel Howtos, Learn Excel
How to Round and Sort Data using Excel Formulas?

Cheryl asks via e-mail, “I was wondering if you could help me figure out how to combine the round formula with the rank formula? I need to first round all the numbers and then rank them.”

Of course we can solve this by simply using array formulas. Curious? Find out more by reading the rest of this post.

Continue »

Sorting Text in Excel using Formulas

Published on Oct 22, 2008 in Analytics, Featured, Learn Excel
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 […]

Continue »

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

Published on Sep 23, 2008 in Analytics, Learn Excel
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 > […]

Continue »

Shuffle a list of numbers / items in excel spreadsheet

Published on Jul 28, 2008 in Learn Excel

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 […]

Continue »

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

Published on Jul 22, 2008 in hacks, Learn Excel, technology

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 […]

Continue »