Looking for more? Try chatting with the Exceljet Chatbot.

Video

3 basic array formulas

Why use array formulas? In this video we'll look at three basic array formula examples. Traditional array formulas can solve tricky problems, and building array formulas in the dynamic array version of Excel is easier than ever...Read more
Video

How to randomly assign people to teams

In this video, we look at a step by step approach to randomly assign people to groups with teams using formulas. Along the way, we use three functions (RAND, RANK, and CEILING), helper columns, and nesting. We verify results with the COUNTIF function.Read more
Video

The UNIQUE function

In this video, we'll introduce the UNIQUE function. The UNIQUE function lets you extract unique values in a variety of ways...Read more
Video

The SEQUENCE function

In this video, we'll introduce the SEQUENCE function. The SEQUENCE function lets you generate numeric sequences, which can be used for dates, times, and more...Read more
Video

How to count unique values

In this video, we'll look at how to count the unique values returned by the UNIQUE function, together with other functions like FILTER and COUNTA...Read more
Video

TEXTAFTER with TEXTBEFORE

You can't always get what you want with the TEXTAFTER function or the TEXTBEFORE function alone. This video walks through two examples that explain how to combine the TEXTAFTER with TEXTBEFORE in a single formula. This might seem like a strange thing to do, but it's a handy trick when you...Read more
Function

EXACT Function

The Excel EXACT function compares two text strings, taking into account upper and lower case characters, and returns TRUE if they are the same, and FALSE if not. EXACT is case-sensitive.Read more

Video

Why pivot tables?

In this video, we compare formulas and pivot tables side-by-side to build the same reports to demonstrate how powerful and easy to use pivot tables are.Read more

Pages