
How to Count unique values with CountIf function?
A common function many people use is the COUNTIF function and that will count any value you choose. But there isn’t one function to count unique values. But we can… Read more »
A common function many people use is the COUNTIF function and that will count any value you choose. But there isn’t one function to count unique values. But we can… Read more »
Leading spaces can cause major issues with automated reports and Excel lookups as values that might have been set previously no longer match what is in the data. Imagine if… Read more »
There comes a time in many Excel users’ careers where we start to write incredibly complex Excel formulas to summarize or extract data from poorly structured workbooks. I’m not talking… Read more »
I guess we are all familiar with the MONTH function in Excel. If you give it a date as an argument, it will return the month number. So far so… Read more »
Excel Multi-cell array formulas are a single formula which returns multiple values and is entered into multiple cells. Hence ‘multi’ in the name. Let’s look at an example, say we… Read more »
Here’s a nifty little trick I use every day while working in Excel. It’s a two part trick. Part one will be selecting all the blank cells in a range… Read more »
It can be used as a ‘wrapper’ to hide many different errors; #DIV/0, #NAME?, #NULL, #NUM, #REF, #VALUE, and one of the most common being VLOOKUP’s #N/A error. In this… Read more »
SUM, COUNT, AVERAGE SUM allows you to sum any number of columns or rows by selecting them or typing them in, for example, =SUM(A1:A8) would sum all values in between… Read more »
Suppose you receive a spreadsheet with calculations, but the calculations are stored as text, for display purposes only, and not used to actually derive answers. Without wanting to reinvent the… Read more »