# Robert Gascon’s Shortest Formula Challenge

Robert Gascon not only created a shortest formula challenge but he also challenged me to write a post about it! Continue reading

# Kevin’s Formula Challenge

My friend Robert Gascon was thinking about Excel formula challenges and Kentucky Fried Chicken (he loves KFC) while drinking a beer. Continue reading

# Power Query Challenge – What Did They Order from the Menu?

Alan Murray (Computergaga) had an interesting challenge on YouTube. It’s a classic case of “Analyze my awkward dataset!”. He solved it using Power Query. Can it be solved using formulas? Continue reading

# mmult function

MMULT function is incredibly powerful and yet mysterious to most. Let’s explore this complex function (this post inspired by a formula challenge from contextures.com )

# How many unique List 1 names found in List 2?

Imagine two lists of names. We have three questions: (1)how many unique names in List 1? (2)how many unique names in List 2? (3)how many unique names from List 1 are found in List 2?  Continue reading

# Extract Largest Number (Power Query & Flash Fill solutions)

In a recent post I audited my colleague’s amazing array formula. It extracted the largest number from as420lkjs09nsdk2324lkjsd099 See other solutions suggested by YouTube viewers! Continue reading

# 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). Continue reading