Excel: How to count unique items in a list
Using dynamic arrays, PivotTables, and the SUMPRODUCT function are three approaches to this common task.
Using dynamic arrays, PivotTables, and the SUMPRODUCT function are three approaches to this common task.
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.