This tutorial will present one way to return an average of an Excel range, whilst ignoring blanks, text, errors, as well as excluding the largest…
Largest value in Excel range (advanced approach) – ignore blanks, texts or errors
This video will present a solution for returning the largest value across a data range, which contains text, errors and blanks. In normal circumstances we…
How to change from exponential to number format in Excel – Advanced
Welcome, this is a follow-on video to an earlier presentation with solving exponential number format problems with numerical cells, especially when dealing with Excel csv…
How to change from exponential to number format in Excel
This article will show one approach to correct the exponential number format referencing issue in a cell, especially when dealing with csv files. Sometimes, as…
XIRR formula across multiple sheets
Goal: We want to calculate the respective IRR for each entity on the summary sheet. Each entity contains its own worksheet, thus we need to…
XLOOKUP formula across multiple sheets
Download Spreadsheet Vault SpreadsheetVault – XLOOKUP formula across multiple sheets (solution).xlsb