Sum top n values in a range

LARGE-and-SEQUENCE-functions-vertical-array

To sum the largest n values in a range, you can use a formula that combines the SUM, TAKE, and SORT functions.

Sum last n columns

sum last n columns excel

To sum last n columns in a range or a table, you can use the SUM and TAKES functions in Excel instead of long formulas.

Sum last n rows

How to sum the last n rows in Excel

To sum the last N rows in a range, you can use the SUM function with the TAKE function, or apply a workaround using the OFFSET function.

Sum every nth row

sumproduct-row-mod-workaround

Learn how to sum every nth row (for example, every second, third, or fifth row) in Excel using the SUMN or SUMPRODUCT function.

Split dimensions into two parts

split-dimensions-into-two-parts

This tutorial will show you how to split dimensions into two parts and extract the left and right dimensions into separate values.

Abbreviate names or words

how-to-abbreviate-names-or-words-in-Excel

Learn how to abbreviate names or words using regular Excel functions or the ABBREVIATE user-defined function

VLOOKUP multiple matches

vlookup-multiple-matches

Today’s guide will show how to return and display multiple matches using the VLOOKUP function or apply the FILTER function.

Trim text to n words

trim-text-to-n-words-in-Excel

How to trim text to n words? We will show you various methods (regular functions and VBA) to get the first n words from a text string.

Wildcard

how to use wildcard in Excel

Excel wildcard is a special character that helps you find text values that are approximately similar but are not exactly the same.

Get last name from name

Get last name from name in Excel - formula examples

Get the last name from a full name quickly using the RIGHT, FIND, LEN, and SUBSTITUTE functions, or use an advanced Excel formula.

Get first name from name

Get first name from name

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

Remove characters from right

remove-characters-from-right-in-Excel

Learn how to remove characters from the right of the text using Excel functions. Discover how to remove the last n characters from a string.