Searching for a Value that has Multiple Entries in the Table

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

REPLACE Function – Changing Existing Text with New Text

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

How to Change and Substitute Specific Text in Excel

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

How to Compare Two Columns

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

Difference Between Absolute and Relative Cell Referencing

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

Rounding Numbers and Decimals in Excel

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

Using Check Boxes in Excel

Check boxes in Excel are a useful tool in creating checklists or to-do lists. They are simple to use. Everyone knows how to use a checklist. Users only have two options: tick the checkbox or deselect it. In this article, we will go through step by step how to add check boxes in Excel. And … Continue Reading