Running counts
Running counts are useful for keeping track of how many times a value has occurred up to a certain point. There are multiple ways of doing this, so let’s look at some traditional and modern methods. Example On page 1,…
Where was Newcastle‘s spectacular pre-match mosaic created?
I love to hear about obscure uses for Excel. Why? Because it debunks the notion it’s purely a number-crunching tool used for a certain activity, by a certain group of people, in a certain place, and at a certain time….
An Alternative to Formulas
Still writing formulas? You won’t be soon. Slight exaggeration. Anyway… Excel Formula Bot is a free AI-based generator that converts your plain English (or Spanish) instruction(s) into a formula. The creator, David Bressler, claims to have built it ‘without a…
Sparklines
A sparkline is a tiny in-cell chart that provides a visual representation of data. They are useful for casually glancing over data to spot trends and variation. Moreover, they conserve space, negating the need to have an overload of full-scale…
Evaluate Formula Parts in Excel
Formulas can often be difficult to understand, so breaking them down makes it easier to see what each part evaluates to. This can be done by selecting a function’s argument in the tooltip, or by highlighting a specific part of…
XLOOKUP or FILTER to find the highest sales?
There are numerous ways of finding the highest value in a column and returning another in the matching row. Let’s have a look at two. In the example, a table called tblSales is present on the left. Method 1 uses…
End of content
End of content