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,…
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….
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…
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…
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…
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
