## 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 in an descending order also removing blanks

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

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

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

Sort text cells alphabetically from two columns

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 [Array formula]

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 and ignore 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 based on value frequency

Learn how to sort cell values by frequency.

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

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

Split values equally into groups

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

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