Download the featured file here. In this video I demonstrate how to convert European formatted numbers to UK format. For example in the data displayed below the thousand separator is a full-stop and the decimal separator is a comma. For a UK format we would want these the other way around…
Read More
Category: Excel Tutorial
How to Calculate Percentage Increase or Decrease in Excel
In this video I demonstrate how increase or decrease a value by a specified percentage. These types of calculations are useful when adding VAT or markup or applying a discount. You can download the featured file here.
Read More
Create a Multi Column Non-Contiguous Return Array Using XLOOKUP
In this video, I demonstrate how to create a non-contiguous return array when using XLOOKUP. The CHOOSE function does the trick here as you will see in the formula below. I created an array of index numbers {1,2,3} which correspond to the columns I have selected in the value 1, value 2 and value 3…
Read More