Looking for more? Try chatting with the Exceljet Chatbot.

Function

NOT Function

The Excel NOT function returns the opposite of a given logical or Boolean value. When given TRUE, NOT returns FALSE. When given FALSE, NOT returns TRUE. Use the NOT function to reverse a logical value.Read more

Formula

XLOOKUP with complex multiple criteria

Normally, the XLOOKUP function is configured to look for a value in a lookup array that exists on the worksheet. However, when the criteria used to match a value becomes more complex, you can use Boolean logic to create a lookup array on the fly composed...Read more

Function

WORKDAY Function

The Excel WORKDAY function returns a date in the future or past that is a given number of working days from a specified start date, excluding weekends and (optionally) holidays. You can use the WORKDAY function to calculate things like start dates, delivery dates, and completion dates...Read more

Formula

Break ties with helper column and COUNTIF

In this example, the goal is to retrieve information about the lowest three estimates in the data shown. The problem is that there are some duplicate values in the estimate column. This means we will have some trouble trying to display the names of the 2nd and 3rd lowest suppliers because the...Read more

Function

LET Function

The Excel LET function lets you define named variables in a formula. There are two primary reasons you might want to do this: (1) to improve performance by eliminating redundant calculations and (2) to make more complex formulas easier to read and write....Read more

Function

SEARCH Function

The Excel SEARCH function returns the location of one text string inside another. SEARCH returns the position of find_text inside within_text as a number. SEARCH supports wildcards, and is not case-sensitive....Read more

Formula

Currency exchange rate example

In this example, the goal is to get monthly currency exchange rates for a given currency pair (i.e., USD > EUR, USD > GBP, CAD > JPY, etc.). Currency abbreviations are entered in cells F5 and F6, and the start and end dates are entered in cells F7 and F8. If any of these four...Read more

Video

How to work with times

In this video we'll look at functions that will let you extract the hour, minute, and second values from a time, as well as a function called TIME that will let you put them together again...Read more
Function

GROUPBY Function

The Excel GROUPBY function is designed to summarize data by grouping rows and aggregating values. The result is a summary table created with a single formula.Read more

Article

19 tips for nested IF formulas

Are nested IFs evil? Are they necessary? Are there alternatives? The answer is Yes! This in-depth article explores nested IF formulas in detail, with lots of tips, and several alternatives.Read more

Term

XLFN

If you open up a spreadsheet that you did not create, you may run into the "__xlfn" prefix before certain functions. The generic meaning of xlfn is "unsupported function". Typically, it indicates that the worksheet was created in a newer version of Excel and uses functions not yet available in...Read more

Article

23 things you should know about VLOOKUP

Although VLOOKUP is a pretty simple function, there is plenty that can go wrong. Quickly learn more than 20 things you should know about VLOOKUP to make your experience pleasant and profitable.Read more

Function

WORKDAY.INTL Function

The Excel WORKDAY.INTL function returns a date in the future or past that is a given number of working days from a specified start date, excluding weekends and (optionally) holidays. Unlike the simpler WORKDAY function, WORKDAY.INTL can be...Read more

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

Pages