## 'LARGE function' category

How to use the LARGE function

The LARGE function calculates the k-thÂ largest value from an array of numbers. Use the LARGE function, for example, to extract […]

The LARGE function calculates the k-thÂ largest value from an array of numbers. Use the LARGE function, for example, to extract […]

Rotating unique groups with no repeat

This article demonstrates a formula What's on this page Question Formula Array formula Explaining array formula Get the Excel File […]

This article demonstrates a formula What's on this page Question Formula Array formula Explaining array formula Get the Excel File […]

Sort items by adjacent number in every other value

This article demonstrates a formula that sorts items arranged horizontally based on the adjacent numbers, every other column contains a […]

This article demonstrates a formula that sorts items arranged horizontally based on the adjacent numbers, every other column contains a […]

Sort based on frequency row-wise

In this article, I will demonstrate two techniques for counting per row. The first example is simple and straightforward. The […]

In this article, I will demonstrate two techniques for counting per row. The first example is simple and straightforward. The […]

Dynamic scoreboard

This article demonstrates a scoreboard, displayed to the left, that sorts contestants based on total scores and refreshes instantly each […]

This article demonstrates a scoreboard, displayed to the left, that sorts contestants based on total scores and refreshes instantly each […]

How to build a Team Generator – different number of people per team

JD asks in this post:Â Dynamic team generator Hi, what if we have different number of people per team? So in […]

JD asks in this post:Â Dynamic team generator Hi, what if we have different number of people per team? So in […]

Find the most/least consecutive repeated value [VBA]

This postÂ Find the longest/smallest consecutive sequence of a value has a few really big arrayÂ formulas. Today I would like to […]

This postÂ Find the longest/smallest consecutive sequence of a value has a few really big arrayÂ formulas. Today I would like to […]

Extract the most repeated adjacent values in a column

The array formula in cell D3 returnsÂ the the length of longest consecutive sequence of a value in column A. Â Cell […]

The array formula in cell D3 returnsÂ the the length of longest consecutive sequence of a value in column A. Â Cell […]

Sort by multiple columns

This article demonstrates how to sort a data set by multipe columns using the SORTBY function, Ecel Table and Excel […]

This article demonstrates how to sort a data set by multipe columns using the SORTBY function, Ecel Table and Excel […]

Assign records unique random text strings

This article demonstrates a formula that distributes given text strings randomly across records in any given day meaning they may […]

This article demonstrates a formula that distributes given text strings randomly across records in any given day meaning they may […]

Find smallest and largest unique number

This article explains how to calculate the largest and smallest number based on a condition which is if the number […]

This article explains how to calculate the largest and smallest number based on a condition which is if the number […]

Plot buy and sell points in an Excel Chart based on two moving averages

This article demonstrates how to display buy and sell signals on an Excel chart based on two moving averages, the […]

This article demonstrates how to display buy and sell signals on an Excel chart based on two moving averages, the […]

Unique distinct records sorted based on count or frequency

This article demonstrates how to sort records in a data set based on their count meaning the formula counts each […]

This article demonstrates how to sort records in a data set based on their count meaning the formula counts each […]

Calculate running average of last 10 data with random blank cells

Question: List of data and blank cells in a column which will be added from day to day. There are […]

Question: List of data and blank cells in a column which will be added from day to day. There are […]

Sort rows based on frequency and criteria

Andre asks:I am trying to list people with the highest scores based on certain criteria. My data: column A B […]

Andre asks:I am trying to list people with the highest scores based on certain criteria. My data: column A B […]

Sort a list in random order in excel

Overview The array formula in cell range C2:C6 creates a random list from the values in cell range A2:A6. Array […]

Overview The array formula in cell range C2:C6 creates a random list from the values in cell range A2:A6. Array […]

True round-robin tournament

Mark G asks in Create a random playlist in excel: Can this example be modified to create a true round-robin […]

Mark G asks in Create a random playlist in excel: Can this example be modified to create a true round-robin […]

Dynamic team generator

Mark G asks: 1 - I see you could change the formula to have the experssion COUNTIF($C$1:C1, $E$2:$E$5)<5 changed so […]

Mark G asks: 1 - I see you could change the formula to have the experssion COUNTIF($C$1:C1, $E$2:$E$5)<5 changed so […]

Create a random playlist

This article describes how to create a random playlist based on a given number of teams using an array formula. […]

This article describes how to create a random playlist based on a given number of teams using an array formula. […]

Team Generator

This blog article describes how to create teams randomly. There are twenty names in column B and four teams in […]

This blog article describes how to create teams randomly. There are twenty names in column B and four teams in […]

Find the most recent date that meets a particular condition

This article demonstrates how to return the latest date based on a condition using formulas or a Pivot Table. The […]

This article demonstrates how to return the latest date based on a condition using formulas or a Pivot Table. The […]

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

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

Reverse a list ignoring blanks

This article demonstrates two different formulas, one for Excel 365 and one for earlier versions. Table of Contents Reverse a […]

This article demonstrates two different formulas, one for Excel 365 and one for earlier versions. Table of Contents Reverse a […]

How to create a list of random unique numbers

Question: How do I create a random list of unique numbers from say 1 to 10, without using VBA and […]

Question: How do I create a random list of unique numbers from say 1 to 10, without using VBA and […]

Sort column based on frequency

This article demonstrates a formula that sorts cell values by their frequency, in other words, how many times a value […]

This article demonstrates a formula that sorts cell values by their frequency, in other words, how many times a value […]

Extract unique distinct values from a multi-column cell range

This article demonstrates ways to list unique distinct values in a cell range with multiple columns. The data is not […]

This article demonstrates ways to list unique distinct values in a cell range with multiple columns. The data is not […]

How to identify two consecutive dates in a list

Question: How to identify two consecutive dates in a list? Answer: Array formula in cell B1: =IFERROR(LARGE(IF((A1+1)=$A$1:$A$30,A1+1,""),1),"") How to enter […]

Question: How to identify two consecutive dates in a list? Answer: Array formula in cell B1: =IFERROR(LARGE(IF((A1+1)=$A$1:$A$30,A1+1,""),1),"") How to enter […]

Find the smallest number in a list that is larger than a given number

This article demonstrates formulas that lets you extract the smallest number larger than a given number. The example above specifies […]

This article demonstrates formulas that lets you extract the smallest number larger than a given number. The example above specifies […]