Video
FILTER data between two dates
In this video, we’ll look at a couple ways to use the FILTER function to extract data between dates.
...Read more
Search results
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
Video
How to create zebra stripes with conditional formatting
In this video, we'll look at how to use conditional formatting to shade every other row in a table. This is sometimes called "zebra striping"...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
Video
How to highlight approximate match lookups
In this video, we'll look at how to highlight the results of approximate match lookups with conditional formatting...Read more