Formula

Learn how to sum every n rows down in Excel using the SUMN_ROWS function or regular (SUM, OFFSET) functions.

This quick guide will show you how to get the nth value in a column using the CHOOSEROWS function in Excel.

In this tutorial, you will learn how to return the nth value in a row using the CHOOSECOLS Excel function.

Learn how to extract a number from a text string in Excel (from the left, right, or any position) using custom formulas and functions.

Learn how to use the MEDIAN IF array formula to identify the middle number of values that meet specific criteria.

Learn how to lookup and return the nth value (or the second, third or nth match) in Excel using the NVLOOKUP function.

To return multiple lookup values in one cell in Excel separated by a comma, use the MLOOKUP or MLOOKUP_NR functions.

To sum the largest n values in a range – sum top n values in Excel – you can use the SUMHIGH function.

Learn how to convert a date to a number or convert a serial number to a date using Excel.

This Excel guide will show you how to return and display multiple matches using the VLOOKUP function.

Learn how the get the first name from a name using regular (LEFT, FIND) and user-defined (TextLeft, ExtractWord) functions.

Learn how to remove file extensions from a filename using custom Excel functions. Also, use the LEFT and FIND functions to clean data.