## Excel – Sort using array formulas

### Create a new sorted list from a column using array formula

Table of Contents Sort a column using array formula Two columns sorting by the second column Sort alphanumeric values I […]

Sorting numbers and text cells also removing blanks using an array formula

Question: How do I sort text and numbers and also removing blanks using an array formula? Answer: Array formula in […]

Sorting numbers and text cells descending also removing blanks using array formula in excel

This blog article is one out of five articles on the same subject. Sorting text cells using array formula in […]

Create a unique distinct alphabetically sorted list extracted from a column

The formula in cell D3 extracts unique distinct values sorted A to Z, from column B to column D. Unique […]

### Create a new sorted list from two columns using array formula

Sort text cells alphabetically from two columns using excel array formula

Table of Contents Sort text from two columns combined (array formula) Sort text from multiple cell ranges combined (user defined […]

### Create a new sorted list from a range using array formula

Sort a range from A to Z using array formula in excel

Question: How do I sort a range alphabetically using excel array formula? Answer: Array formula in B8: =INDEX($B$2:$E$5, MIN(IF(SMALL(COUNTIF($B$2:$E$5, "<"&$B$2:$E$5), […]

Extract a unique distinct list sorted alphabetically removing blanks from a range

This is an answer to a question in this blog post: Extract a unique distinct list sorted from A-Z from […]

### Misc

Sort a range by occurence using array formula in excel

Learn how to sort cell values by frequency.

Sort text values by length using array formula in excel

Array formula in B2: =IF(ROWS(B2:$B$2)>ROWS(List), "", INDEX(List, MATCH(LARGE((LEN(List)&","&ROW(List))*1, ROWS(B1:$B$1)), (LEN(List)&","&ROW(List))*1, 0))) + CTRL + SHIFT + ENTER copied down as […]

Create and sort distinct list by adjacent cell value size

Question: How do I create a distinct list from another list and then sum adjacent value and sort distinct list […]

Sort cell values into categories

Here are the prerequisites. Column A contains dates, column B are categories and column C are values. The goal with […]

Sort cell values into categories, part 2

In this article I am going to enhance a previous article "Sort cell values into categories". Here is a picture […]

Split values equally into groups using excel array formula

Question: How do I divide values equally into groups (3 lists or less)? This post shows you two different approaches, […]

Split first and last names in excel and then sort them alphabetically

Debra Dalgleish at Contextures blog wrote an article Split First and Last Names in Excel. It gave me an idea […]

### Dates

How to sort text cells filtered by two dates, part 2

In a previous article How to sort cells filtered by two dates I came up with a solution on how […]

How to sort cells filtered by two dates

Question: I have a list containg dates and values. How do I sort values between two specific dates? Answer: Yellow […]

Question: How do I sort date ranges or intervalls by size in excel? Answer: Here are the ranges sorted large […]

Sort dates within a date range using excel array formula

Question: I have a list of unsorted dates. I want to extract records between two dates and I want the […]