## Look for keywords inside of a column of text values

On October 17 we celebrated spreadsheet day. It was a day full of excitement around the globe! Crowds gathered around spreadsheets…dancing and drinking occurred into the wee hours of the morning. Part of the celebration included a lookup formula challenge from Debra Dalgleish (spreadsheet day creator). (more…)

## Video 00167 Sliding Formula Ranges

Data lands in Microsoft Excel in many different structures. Data Analysts like me will often tell you to normalize your data before starting your analysis. This post contains three examples in which normalizing your data might not be necessary when doing a quick analysis. (more…)

## Video 00166 Count Groups Above or Below Targets

This Excel puzzle almost sounds like it could be solved with a quick COUNTIFS function but it’s a bit more involved than that. Nevertheless, it doesn’t have to get complicated as it can still be solved using a few simple steps. (more…)

## Video 00163 Creating a Weighted Random Dataset

It’s easy to create some random data using RANDBETWEEN and INDEX functions. But what if you want to create random data that favors or repeats some values over others? People have told me that they spend time copying and pasting or manually dragging the values to repeat them. Keep reading to see how we can automate this with just four easy steps! (more…)

## Video 00162 Excel Formula Calculates Value of Chess Pieces

I visit many different Excel blogs. Every once in a while I learn something completely new that really boggles my mind! And in this case the Chess world overlaps the Excel world so it was REALLY amazing (and nerdy)! How do I start to explain how awesome this is? (more…)

## Video 00161 Extract Matrix Non Blanks Into 1 Column

Have you ever visited excelxor.com ? It’s an amazing blog with a lot of Excel formula challenges. Here’s one challenge: “given the the 6-by-4 array on the left we may wish to create the single-column on the right(more…)

## Video 00160 Sum Values From Qualifying Mini Tables

Sometimes life is stranger than fiction. If we were to create this requirement as a hypothetical case many would say that it would never happen. Well, this was a real question that someone had for me. Read this post to see the requirements and how I solved this. I’ve also included alternative solutions from the Excel community. (more…)

## Video 00156 One Complex Formula or Helper Formulas?

There are many factors to consider when creating a solution in Excel. Are we building the solution for someone else with basic Excel skills? Should we use a complex formula in only one column to save space or use helper formulas to simplify the solution? Let’s take a look at this question from Mike Girvin’s ExcelIsFun YouTube channel. (more…)