Looking for more? Try chatting with the Exceljet Chatbot.

Function

ABS Function

The Excel ABS function returns the absolute value of a number. ABS converts negative numbers to positive numbers, and positive numbers are unaffected.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

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
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