Formulas

To count unique dates you can use a formula based on the UNIQUE and COUNT functions or apply the COUNTIF and FREQUENCY functions.

In this tutorial, you will learn how to calculate CAGR in Excel, either using the RRI function or through manual calculation.

Learn how to create a mortgage payment schedule in Excel using a formula based on multiple dynamic array functions.

To generate random numbers without duplicates you can use a formula based on the SORTBY, UNIQUE and RANDARRAY functions.

To extract the first number before a text string, use a formula based on the VALUE and REGEXEXTRACT functions.

To extract the last number from a string you can use a formula based on the TEXT and REGEXEXTRACT functions with a specific pattern.

To get a number from any position in a string, use a formula based on the TEXTJOIN, TRUE, IFERROR, MID, ROW, INDIRECT and LEN functions.

To extract the nth number from a text string, use a formula based on the INDEX, TOROW and TEXTSPLIT functions.

To calculate effective annual interest rate use the EFFECT functiom based on the nominal interest rate and the compounding frequency.

To calculate the number of payment periods for a loan in Excel, you can use a formula based on the NPER function.

To calculate cumulative loan interest based on the interest rate, loan amount, monthly payments and period, use the CUMIPMT function.

To calculate the periodic interest rate for a loan based on the loan amount, payment periods, and payment amount, use the RATE function.

To calculate payment for a loan in Excel, based on an interest rate, loan term, and amount, use the PMT function.

To calculate the original loan amount, you can use the PV function if you have the loan term, interest rate, and periodic payment amount.

To calculate the cumulative principal paid between any two loan payments in Excel, you can use a formula based on the CUMPRINC function.

To calculate annual compound interest, you can use a formula based on the SEQUENCE function, starting balance and annual interest rate.

To filter data with multiple criteria, you can use a formula based on the FILTER function combined with the boolean logic.

To count rows in a range that meets multiple criteria, use a formula based on the ROWS and FILTER functions or apply the SUMPRODUCT function.

To count values in multiple ranges with criteria, you can use a formula based on SUM and VSTACK functions and the boolean logic.

To extract a date from a text string, you can use a formula based on the TOROW and REGEXEXTRACT functions.

To sum numbers in a single cell separated by a given delimiter, you can use a formula based on the TEXTSPLIT and VALUE functions.

To sum numbers with a text string, you can use a formula with the SUM and TEXTAFTER functions or the LET function.

To create a dynamic summary count with a formula, you can use the CHOOSE, UNIQUE, and COUNT functions to return unique values.

To count numbers in a range that begin with specific numbers, use a formula based on the SUMPRODUCT and LEFT functions.

To filter data if a cell contains specific text in Excel, you can use a formula based on the FILTER, ISNUMBER, and SEARCH functions.

To FILTER and extract the first or last n values in Excel, use a formula based on the TAKE, FILTER, INDEX, and SEQUENCE functions.

To count unique numeric values in a range, you can use a formula based on the COUNTA, UNIQUE, FILTER and ISNUMBER functions.

To count total matches in two ranges using Excel, you can use a formula based on the SUM and COUNTIF functions.