formulas

Find Multiple Values in Excel

Find and Replace The easiest way to find multiple values in Excel is to use the Find feature. First, select cells you want…

When you work with multiple columns of data, which is usually the case, sometimes it may be smart to simplify data. For example,…

In this article, I’ll present how you can extract or remove the text before and after a character. In the later part, there…

To convert a standard date to month and year, you can use the TEXT function. This function converts a value to text in…

With the COUNTIF function, you can count the number of cells that meet a single condition. The following example contains a list of…

When you deal with several cells inside your spreadsheet data, adding commas manually in particular places inside cells may be a good decision,…

In this example, we are going to calculate the change in revenue for the first 6 months of the year. For this lesson,…

By beaking a formula, I mean writing a formula in multiple rows, instead of one. Usually, when we write some text, we use…

Vlookup stands for vertical lookup. In other words, vlookup searches for information in a column. If you want to search for information in…

Let’s take a look at the current example. You are traveling the world and there is a list of expenses you made. Each…