If your spreadsheet contains a list of times, it is useful to group time in Excel into intervals such as 30 minutes, hourly or every 6 hours.
Fortunately, Excel provides a variety of methods to group time depending on what you need. In this blog post, we look at 4 ways to group time in Excel using PivotTables and formulas.
[Read more…] about 4 Ways to Group Time in Excel – PivotTables and FormulasThe Excel MOD function is used to return the remainder after one number is divided by another. Simple, but there are some very useful examples of the MOD function.
In this blog post, we explore 4 Excel MOD function examples. Hopefully this will help to see how versatile this function can be.
To start we better have a quick introduction to how to use the MOD function. It looks like this;
=MOD(number, divisor)
You need to provide it first with the number you want to divide, and then the number you want to divide it by (divisor).
You can see some basic examples of this below.
Ok, lets get on with some more impressive real-world Excel MOD function examples.
[Read more…] about Excel MOD Function – 4 ExamplesIn this blog post, we look at how to highlight the cells that contain a specific word. We will also ensure that the word in the cell matches the case of the word being looked for.
For this example, we have a list of the Ballon d’or winners of all time. Column B contains 3 letters in uppercase (after the name) which identify the country that the player represented at the time of winning the award.
In cell E1 I have entered the 3 digits for a country. I would like to automatically change the colour of all the cells that contain the country written in E1.
There is a good chance that the 3 digits identifying a country could also occur in a players name. For example, the letters for France – FRA do occur in the name Franz Beckenbauer.
To prevent this happening, we will match the case of the word we are searching for, as it is always written in upper case.
[Read more…] about Highlight the Cells that Contain a Specific Word (and it Matches Case)When learning the VLOOKUP function, one of the things people can struggle with is seeing why this function is so useful. In this blog post, we look at 4 Excel VLOOKUP examples.
The purpose of VLOOKUP is to look for a value and return some information about that value. Although quite specific in its role, this function can be used in some very clever and interesting ways.
For anyone reading this who may be quite new to VLOOKUP, lets have a quick look at its structure.
=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
For more information on how to use VLOOKUP, check out the Ultimate VLOOKUP guide.
If you would prefer to watch the video, or simply watch it whilst you refer to the formulas in this tutorial. You can do so below.
Use wildcard characters in Excel formulas to perform partial matches on text. This can be extremely useful. Excel allows the use of wildcards in filters, the Find and Replace tool and especially in formulas.
This blog post explores some examples of using wildcard characters in formulas to find, sum or count cells containing partial matches to what we are searching for.
If you prefer a video tutorial, then check it out below, otherwise please continue for the written tutorial.
Before we look at some examples of wildcard characters in Excel formulas, we should discuss the three types of wildcard characters you can use in Excel.
[Read more…] about Using Wildcard Characters in Excel Formulas
