Excel: How to reference a row dynamically
Excel MVP Liam Bastick explains the OFFSET(COUNTA) function combination, used for dynamic lookups.
Excel MVP Liam Bastick explains the OFFSET(COUNTA) function combination, used for dynamic lookups.
Breaking the y-axis on a chart can be a useful way to display data, but the technique should be used with discretion, says Excel MVP Liam Bastick.
Many options exist to search for data in Excel, but what do you do if the data is in a range?
Take a LINKS function stored as a defined range name and Transpose it via dynamic arrays.
Excel MVP Liam Bastick provides a formulaic solution to the common financial modelling issue of how to correctly prorate amounts over time.
In this first of a two-part article, Excel MVP Liam Bastick introduces you to one group of functions that manipulate text and another group that combine arrays.
In this second of a two-part article, Excel MVP Liam Bastick introduces you to new functions that shape and resize arrays.
This article shows how to set up Excel spreadsheets to efficiently determine weighted averages and avoid common mistakes.
Excel MVP Liam Bastick talks about XLOOKUP, SUMPRODUCT, OFFSET, and MOD functions, limitations of the spreadsheet software, and his wish list of changes for Excel.
Excel trainer Liam Bastick discusses the most common mistake accountants make when using Excel, whether Excel is outdated, and the new LAMBDA function.