Category: formulas

We have all been in a situation where we realize that we have made the same error in a whole document, or a…

If you have been using Excel at any point, you have certainly heard of the VLOOKUP function. Now, although this function is pretty…

If you work with a database and have someone’s birth date but you need to create a column that shows only the year…

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

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 a month and year, you can use the TEXT function. This function converts a value to text…

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