Search

# All articles with 'sorting' Tag

## How to Round and Sort Data using Excel Formulas?

Published on Jul 6, 2009 in Excel Howtos, Learn Excel

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 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

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 »

### Get FREE Excel & Power-BI Newsletter

One email per week with Excel and Power BI goodness. Join 100,000+ others and get it free.