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

Sort a column alphabetically
Table of Contents Sort a column - Excel 365 Sort a column using array formula Two columns sorting by the […]

Recommended articles

Recommended articles

Recommended articles

Extract a unique distinct list sorted from A to Z
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 Recommended articles

Sort text cells alphabetically from two columns
Table of Contents Sort text from two columns combined (array formula) How to create an array formula How to copy […]

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

Sort a range from A to Z [Array formula]
Question: How do I sort a range alphabetically using excel array formula? Answer: Cell range \$B\$2:\$E\$5 contains text values in random […]

Recommended articles

Extract unique distinct values A to Z from a range and ignore blanks
This article demonstrates formulas that extract sorted unique distinct values from a cell range containing also blanks. Unique distinct values […]

### Misc Recommended articles

Sort a range based on value frequency
The formula in cell B8 extracts a list sorted based on frequency. Array formula in B8: =TEXTJOIN("", TRUE, IF(MIN(IF((MAX(IF(COUNTIF(\$B\$7:B7, \$B\$2:\$E\$5)=0, […] Recommended articles

Sort text values by length
The image above demonstrates a formula in cell D3 that sorts values based on character length, the value with the […]

Recommended articles

Recommended articles

Recommended articles

Recommended articles

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

Recommended articles

### Dates

Recommended articles

Recommended articles

Recommended articles

Recommended articles

Sort dates within a date range
Array formula in D5: =SMALL(IF((\$B\$3:\$B\$12<=\$E\$3)*(\$B\$3:\$B\$12>=\$E\$2), \$B\$3:\$B\$12, "A"), ROWS(\$A\$1:A1)) How to create an array formula Copy array formula Select cell D5 […]