In this blog post we create a reverse FIND formula to extract text after the last occurrence of a character.
Many of you reading this may already be familiar with the FIND function. You would probably have used it with LEFT or MID to locate a delimiter character, and return text before, or after that character.
In this tutorial we want to extract text after the last occurrence of a character, so want to create a reverse find effect.
The GETPIVOTDATA function in Excel is used to query and extract data from a PivotTable. It is essentially a PivotTable lookup formula.
This function can be extremely useful. When your PivotTable updates, it may grow or reduce in size, or the field items may change order – GETPIVOTDATA will continue to extract the correct data.
In this blog post, we will show why the GETPIVOTDATA function in Excel is useful with an example, but then show an example of when we do not want it, and how we can turn the feature off.
[Read more…] about The GETPIVOTDATA Function in ExcelNested IF formulas are extremely useful for complex decision making on a spreadsheet, but they can also be long, messy and convoluted.
This blog post explores 4 alternatives which are easier, faster and cleaner than the classic nested IF.
The CHAR function in Excel returns a character specified by a code, from the character set of your computer.
In this blog post, we look at why you might want to use the CHAR function, and some examples of it in action in Excel.
The CHAR function is typically used to insert, or to find, a character which you ordinarily cannot type from your keyboard.
To use it you will need to find out what the code is for the character you want to use.
You can search online for a full list of these character sets so that you know each code (or at least the one you need at the given time). These character sets differ between the Windows and Mac computers, and are also dependent upon the language used.
[Read more…] about Excel CHAR Function with ExamplesWhen your Excel formula is not calculating, or not updating, it can be very frustrating. Your formulas are the driving force for your spreadsheet.
There are 5 reasons for your Excel formula not calculating. In this tutorial we explain these 5 scenarios.
