Tag Archives: Excel Formulae

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 »

How to remove leading spaces from Excel cells?

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 »

Trick to Complex Excel Formulas

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 »

A trick with MONTH() Function in Excel

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 »

When to use Multi-Cell Array Formulas

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 »

Fill All Blank Cells in an Excel Range With a Desired Value

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 »

IFERROR Puts an End to Messy Workarounds

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 »

Top 10 Most Useful Excel Formulas

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 »

Secret Evaluate Function

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 »