Just so we know where this is heading, this is the end result And here is the file with the end result, you can download it and play around with pressing F9. ...

As promised in the Pragmatism vs. Purity in Excel article from last week, this week’s article will explain the following array formula ...

One of the greatest things about Excel is that with its endless array of tools and commands it almost always offers multiple ways of achieving a certain goal. ...

On many occasions we would like to somehow get the dates belonging to the last day of current, previous or any other month, the first day of this month or any day of ...

We have a dish where I come from (Slovenia), called Minestrone. It’s interesting since there is no single recipe for it. It’s made from whatever ...

One day as I was giving a basic(!!!!) Excel training, my mind got sort of blown. We were discussing the use of A1:A100 in the Name Box for the selection of a range ...

Our goal here, is to create a dropdown list by using Data Validation, where the contents of the list will be determined by another Data Validation Dropdown list. ...

In my work as an Excel Trainer, I do love to challenge the audience. And one of my favorite challenges to extend is the focus of this post. So fill all the cells in ...

A task that comes about every so often in Excel and can be quite tricky. Now our ultimate goal is to get a number out of something like (text 1 text) or even ...

Excel can be very tricky about rounding numbers. Almost half of Excel users still believe that if they format a cell to round to two decimals, that what they see is ...

Excel has quite a few funny perks. Once you get over the 15 digit limit in Excel and the fact it does not calculate exactly as it should, you will sooner or later ...

This will be a short lesson on three great and sadly unknown functions and how to use them as an array function. The eighth LARGEst value One of my favorite ...

We have a column of dates in Excel, and our goal is to get Q1, Q2,… or QTR1, QTR2,… or Quarter 1, Quarter 2,… . I think you get the picture 🙂 First we ...

For the purposes of this article (if you wish to follow long and I strongly suggest you do so) we will be using a workbook that has the A2:E10 Range filled with the ...

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 good. But here is a ...