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

How to use the MAX function
What is the MAX function? The MAX function calculates the largest number in a cell range or array. Table of […]

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

How to use Excel Tables
An Excel table allows you to easily sort, filter and sum values in a data set where values are related.

How to calculate and plot pivots on an Excel chart
  If you study a stock chart you will discover that sometimes significant trend reversals happen when a stock chart […]

Follow stock market trends – Moving Average
In my previous post, I described how to build a dynamic stock chart that lets you easily adjust the date […]

Find and return the highest number and corresponding date based on a condition
Table of Contents Find and return the highest number and corresponding date based on a condition Lookup value based on […]

Working with overlapping date ranges
This article demonstrates formulas that calculate the number of overlapping ranges for all ranges, finds the most overlapped range and […]

Split expenses calculator
This article demonstrates two ways to calculate expenses evenly split across multiple people. The first one is a formula solution, […]

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

Repeat values across cells
  Table of Contents Repeat values Repeat the range according to criteria in loop Find the most/least consecutive repeated value […]

Fuzzy VLOOKUP
This formula returns multiple values even if they are arranged differently or have minor misspellings compared to the lookup value.

Extract dates from overlapping date ranges
The array formula in cell B3 extracts overlapping dates based on the date ranges in columns D and E. What's […]

Convert date ranges into dates
This article demonstrates how to create a list of dates based on multiple date ranges. Table of contents Convert date […]

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

Extract unique distinct values sorted based on sum of adjacent values
Filtering unique distinct text values and sorting them based on the sum of adjacent values can easily be done by […]

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

Extract a unique distinct list sorted from A to Z
This article demonstrates Excel formulas that allows you to list unique distinct values from a single column and sort them […]

How to quickly find the maximum or minimum value [Formula]
This article demonstrates formulas that will return the largest and smallest numbers, the corresponding column headers, the cell addresses, and […]

Working with unique values
What's on this page Extract unique values from two columns - Excel 365 Extract unique values from two columns - […]