The VLOOKUP function searches for the lookup_value in the leftmost column in the table_array and stops when the first match is found. But what if there are multiple entries in the table? Have a look at an example below: There are multiple “Kate N”s in the company. Using VLOOKUP, you will only get Start Date … Continue Reading
In this article, we will have a look at the REPLACE function. We will look at how to use this function to change existing text in a string with new text. We will also look at how the REPLACE function is different to the SUBSTITUTE function and when to use each one. REPLACE Function The … Continue Reading
There could be various reasons why we need to change and substitute certain text in a cell. We have touched on this previously when needed to take out certain part of a string in a cell (How to Extract Part of a Text in Cells). You could be doing this to clean up data or … Continue Reading
There are many different ways to compare two columns. And it depends on how we want to do the comparison? Do we want to simply see if item in one column is in the second column? Do we want to count how many rows have different items? Do we want to specify which rows have … Continue Reading
In this article we will do a step by step guide on how to add up values based on cell colors. And then we will go through how to count the number of cells that are of a particular color. We will be doing so using Visual Basic for Applications (VBA). However this method is … Continue Reading
In Excel we often reference another cell or a range of cells in a function or formula. And we drag the formula down the row so we don’t type the same formula again and again. Inevitably there will be times we want Excel to lock in a particular cell or range and there will be … Continue Reading
If you are interested in rounding numbers and decimals in Excel, you’ve found the right article. In this article, we will go through how to round decimal numbers up and down, specifying how many decimal places we want and also rounding numbers to the nearest multiples. Rounding Decimals – ROUND, ROUNDUP and ROUNDDOWN functions There … Continue Reading