Create a new sorted list from a column using array formula

sort list

Sort a column alphabetically

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

Comments(81) Filed in category: Excel, Sort values

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

Comments(22) Filed in category: Excel

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

Comments(0) Filed in category: Excel

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

Comments(53) Filed in category: Excel

Create a new sorted list from two columns using array formula

sort lists

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

Comments(13) Filed in category: Excel, Sort values

Create a new sorted list from a range using array formula

sort range

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

Comments(3) Filed in category: Excel, Sort values

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

Comments(21) Filed in category: Excel

Misc

occurances

Sort a range by occurence using array formula in excel

Learn how to sort cell values by frequency.

Comments(4) Filed in category: Excel, Sort values

sort text length

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

Comments(0) Filed in category: Excel, Sort values

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

Comments(1) Filed in category: Excel

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

Comments(7) Filed in category: Excel, Split values

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

Comments(2) Filed in category: Excel

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

Comments(13) Filed in category: Excel, Split values

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

Comments(3) Filed in category: Excel

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

Comments(0) Filed in category: Excel

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

Comments(12) Filed in category: Dates, Excel, Sort values

Sorting date ranges in excel

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

Comments(0) Filed in category: Excel

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

Comments(23) Filed in category: Excel, Sort values