## 'TRUE function' category

Compatibility Functions

Table of Contents How to use the BETADIST function How to use the BETAINV function How to use the BINOMDIST […]

Table of Contents How to use the BETADIST function How to use the BETAINV function How to use the BINOMDIST […]

Array Manipulation Functions

Table of Contents How to use the CHOOSECOLS function How to use the CHOOSEROWS function How to use the DROP […]

Table of Contents How to use the CHOOSECOLS function How to use the CHOOSEROWS function How to use the DROP […]

How to decode URL-encoded strings

This formula decodes a URL-encoded string, replacing specific percentage symbol (%) and a hexadecimal number with non-alphanumeric characters. Excel 365 […]

This formula decodes a URL-encoded string, replacing specific percentage symbol (%) and a hexadecimal number with non-alphanumeric characters. Excel 365 […]

Calculate the number of weeks between given dates

This article demonstrates Excel formulas that calculate complete weeks between two given dates and weeks and days between two given […]

This article demonstrates Excel formulas that calculate complete weeks between two given dates and weeks and days between two given […]

Excel VBA functions

Table of Contents Functions How to use the ARRAY function How to use the FIX function How to use the […]

Table of Contents Functions How to use the ARRAY function How to use the FIX function How to use the […]

Rearrange values in a cell range to a single column

This article demonstrates formulas that rearrange values in a cell range to a single column. Table of Contents Rearrange cells […]

This article demonstrates formulas that rearrange values in a cell range to a single column. Table of Contents Rearrange cells […]

How to use the TRUE function

What is the TRUE function? The TRUE function returns the logical (Boolean) value TRUE. What is a Boolean value? A […]

What is the TRUE function? The TRUE function returns the logical (Boolean) value TRUE. What is a Boolean value? A […]

How to extract numbers from a cell value

What's on this page How to extract numbers from a cell value - Excel 2016 Sort and return unique distinct […]

What's on this page How to extract numbers from a cell value - Excel 2016 Sort and return unique distinct […]

How to remove numbers from a cell value

This article demonstrates an array formula that extracts all characters except numbers from a cell, cell C3 contains the formula […]

This article demonstrates an array formula that extracts all characters except numbers from a cell, cell C3 contains the formula […]

Extract specific word based on position in cell value

Table of Contents Extract first word in cell value Extract the first word in cell - return warning if not […]

Table of Contents Extract first word in cell value Extract the first word in cell - return warning if not […]

SUMPRODUCT and IF function

You don't need to use the IF function in a SUMPRODUCT function, it is enough to use a logical expression. […]

You don't need to use the IF function in a SUMPRODUCT function, it is enough to use a logical expression. […]

INDEX MATCH – Case sensitive

The picture above demonstrates a formula in cell F3 that allows you to look up a value in column B […]

The picture above demonstrates a formula in cell F3 that allows you to look up a value in column B […]

INDEX MATCH – multiple results

Table of Contents INDEX MATCH - multiple results INDEX and MATCH - multiple criteria and multiple results INDEX and MATCH […]

Table of Contents INDEX MATCH - multiple results INDEX and MATCH - multiple criteria and multiple results INDEX and MATCH […]

Match two columns and return another value on the same row

This article demonstrates formulas that match two conditions in a column each and return another value on the same row […]

This article demonstrates formulas that match two conditions in a column each and return another value on the same row […]

If cell contains text from list

This article demonstrates several techniques to check if a cell contains text based on a list. The first example shows […]

This article demonstrates several techniques to check if a cell contains text based on a list. The first example shows […]

If cell contains text

This article demonstrates different formulas based on if a cell contains a given text. Formula in cell C3: =B3=$E$3 The […]

This article demonstrates different formulas based on if a cell contains a given text. Formula in cell C3: =B3=$E$3 The […]

IF function with AND function – multiple conditions

The AND function allows you to have multiple conditions in an IF function, you can have up to 254 arguments. […]

The AND function allows you to have multiple conditions in an IF function, you can have up to 254 arguments. […]

How to use nested IF functions

Nested IF statements in a formula are multipleÂ combined IF functions so more conditions and outcomes become possible. They all are […]

Nested IF statements in a formula are multipleÂ combined IF functions so more conditions and outcomes become possible. They all are […]

Concatenate unique distinct values

This article demonstrates Excel formulas that extract unique distinct values from a cell range and concatenates the values using any […]

This article demonstrates Excel formulas that extract unique distinct values from a cell range and concatenates the values using any […]

Use VLOOKUP to calculate discounts, commissions, tariffs, charges, shipping costs, packaging expenses or bonuses

Have you ever tried to build a formula to calculate discounts based on price? The VLOOKUP function is much easier […]

Have you ever tried to build a formula to calculate discounts based on price? The VLOOKUP function is much easier […]

Split search value using a delimiter and search for each substring

This article demonstrates formulas and a UDF that searches for values in a table based on concatenated values and returns […]

This article demonstrates formulas and a UDF that searches for values in a table based on concatenated values and returns […]

Search for a sequence of cells based on wildcard search

This article demonstrates array formulas that perform a wildcard search based on a sequence of values. The formulas return the […]

This article demonstrates array formulas that perform a wildcard search based on a sequence of values. The formulas return the […]

Working with classic ciphers in Excel

What's on this page Reverse text Insert random characters Convert letters to numbers How to shuffle characters in the alphabet […]

What's on this page Reverse text Insert random characters Convert letters to numbers How to shuffle characters in the alphabet […]

Identify rows of overlapping records

This article demonstrates a formula that points out row numbers of records that overlap the current record based on a […]

This article demonstrates a formula that points out row numbers of records that overlap the current record based on a […]

Lookup multiple values in one cell

This article explains how to perform multiple lookups based on values in one cell with a delimiting character using a […]

This article explains how to perform multiple lookups based on values in one cell with a delimiting character using a […]

How to use VLOOKUP/XLOOKUP with multiple conditions

I will in this article demonstrate how to use the VLOOKUP function with multiple conditions. The function was not built […]

I will in this article demonstrate how to use the VLOOKUP function with multiple conditions. The function was not built […]

How to use mouse hover on a worksheet [VBA]

I recently discovered an interesting technique about using a user defined function in a HYPERLINK function. Jordan at the Option […]

I recently discovered an interesting technique about using a user defined function in a HYPERLINK function. Jordan at the Option […]

Lookup multiple values across columns and return a single value

Table of Contents Lookup multiple values across columns and return a single value Lookup using multiple conditions Lookup a date […]

Table of Contents Lookup multiple values across columns and return a single value Lookup using multiple conditions Lookup a date […]

Rearrange data

Sean asks: Sheet1A B C D 8 Country Europe 9 Lights 100 10 Type A 200 11 12 Country USA […]

Sean asks: Sheet1A B C D 8 Country Europe 9 Lights 100 10 Type A 200 11 12 Country USA […]

Filter unique distinct values, sorted and blanks removed from a range

EEK asks: I am looking for the same formula on this page, but targeting a range of MxN (spanning multiple […]

EEK asks: I am looking for the same formula on this page, but targeting a range of MxN (spanning multiple […]

Vlookup a cell range and return multiple values

VLOOKUP a multi-column range and return multiple values.

VLOOKUP a multi-column range and return multiple values.

VLOOKUP – Return multiple unique distinct values

This article shows how to extract unique distinct values based on a condition applied to an adjacent column using formulas. […]

This article shows how to extract unique distinct values based on a condition applied to an adjacent column using formulas. […]

A Comprehensive Guide to Splitting Text in Excel

This blog article describes how to split strings in a cell with space as a delimiting character, like Text to […]

This blog article describes how to split strings in a cell with space as a delimiting character, like Text to […]

Lookup and return multiple values concatenated into one cell

This article demonstrates how to find a value in a column and concatenate corresponding values on the same row. The […]

This article demonstrates how to find a value in a column and concatenate corresponding values on the same row. The […]

Filter unique strings from a cell range

This blog post describes how to create a list of unique words from a cell range. Unique words are all […]

This blog post describes how to create a list of unique words from a cell range. Unique words are all […]

Populate cells dynamically in a weekly schedule

In this post I am going to add one more function to the weekly schedule I built in a previous […]

In this post I am going to add one more function to the weekly schedule I built in a previous […]

Automate net asset value (NAV) calculation on your stock portfolio

Table of Contents Automate net asset value (NAV) calculation on your stock portfolio Calculate your stock portfolio performance with Net […]

Table of Contents Automate net asset value (NAV) calculation on your stock portfolio Calculate your stock portfolio performance with Net […]

How to return a value if lookup value is in a range

In this article, I will demonstrate four different formulas that allow youÂ to lookup a value that is to be found […]

In this article, I will demonstrate four different formulas that allow youÂ to lookup a value that is to be found […]

Formula for matching a date within a date range

This article demonstrates how to match a specified date to date ranges. The image above shows a formula in cell […]

This article demonstrates how to match a specified date to date ranges. The image above shows a formula in cell […]

Filter unique values from a cell range

Unique values are values occurring only onceÂ in cell range. This is what I am going to demonstrate in this blog […]

Unique values are values occurring only onceÂ in cell range. This is what I am going to demonstrate in this blog […]

Filter unique values sorted from A to Z

A unique value is a value thatÂ only exists once in a list. A unique distinct list contains all cell values […]

A unique value is a value thatÂ only exists once in a list. A unique distinct list contains all cell values […]

How to list unique distinct values sorted by frequency

What's on this page Unique distinct values sorted based on frequency (single column) Unique distinct values sorted based on frequency […]

What's on this page Unique distinct values sorted based on frequency (single column) Unique distinct values sorted based on frequency […]

Find min and max unique and duplicate numerical values

Table of Contents How to find the largest duplicate number How to find the largest duplicate number - Excel 365 […]

Table of Contents How to find the largest duplicate number How to find the largest duplicate number - Excel 365 […]

Filter values in common between two cell ranges

The image above shows an array formula in cell B12 that extracts values shared by cell range B2:D4 (One) and […]

The image above shows an array formula in cell B12 that extracts values shared by cell range B2:D4 (One) and […]

Filter values occurring in range 1 but not in range 2

Table of Contents Filter values occurring in range 1 but not in range 2 Filter not shared values out of […]

Table of Contents Filter values occurring in range 1 but not in range 2 Filter not shared values out of […]

Extract duplicates from a multi-column cell range

This article describes two formulas that extract duplicates from a multi-column cell range, the first one is built for Excel […]

This article describes two formulas that extract duplicates from a multi-column cell range, the first one is built for Excel […]

Search for a text string in a data set and return multiple records

This article explains different techniques that filter rows/records that contain a given text string in any of the cell values […]

This article explains different techniques that filter rows/records that contain a given text string in any of the cell values […]

How to perform a two-dimensional lookup

Table of Contents How to perform a two-dimensional lookup Reverse two-way lookups in a cross reference table [Excel 2016] Reverse […]

Table of Contents How to perform a two-dimensional lookup Reverse two-way lookups in a cross reference table [Excel 2016] Reverse […]

Extract a list of duplicates from a column

The array formula in cell C2 extracts duplicate values from column A. Only one duplicate of each value is displayed […]

The array formula in cell C2 extracts duplicate values from column A. Only one duplicate of each value is displayed […]

Partial match for multiple strings – AND logic

This article demonstrates formulas that let you perform partial matches based on multiple strings and return those strings if all […]

This article demonstrates formulas that let you perform partial matches based on multiple strings and return those strings if all […]

Sum unique numbers

Table of Contents Sum unique numbers Get Excel *.xlsx file Sum unique distinct numbers Get Excel *.xlsx file Sum number […]

Table of Contents Sum unique numbers Get Excel *.xlsx file Sum unique distinct numbers Get Excel *.xlsx file Sum number […]

5 easy ways to extract Unique Distinct Values

First, let me explain the difference between unique values and unique distinct values, it is important you know the difference […]

First, let me explain the difference between unique values and unique distinct values, it is important you know the difference […]

How to extract email addresses from an Excel sheet

Question: How to extract email addresses from this sheet? Answer: It dependsÂ on how the emails are populated in your worksheet? […]

Question: How to extract email addresses from this sheet? Answer: It dependsÂ on how the emails are populated in your worksheet? […]

Cleaning Up Excel Worksheets: Eliminating Blank Cells, Rows, and Errors

In this blog post I will demonstrate methods on how to find, select, and deleting blank cells and errors. Why […]

In this blog post I will demonstrate methods on how to find, select, and deleting blank cells and errors. Why […]

## Excel formula categories

AverageChooseCombine MergeCompareConcatenateConditional FormattingCountCount valuesDatesDuplicatesExtractFilterFilter recordsFiltered valuesFilterxmlHyperlinkIf cellIndex MatchLogicLookupsMatchMaxMinNumbers in sumOR logicOverlappingPartial matchRecordsSequenceSmallSort bySort valuesSumSumifsSumproductString manipulationTimeUnique distinct recordsUnique distinct valuesUnique recordsUnique valuesVlookupVlookup return values