I enjoy the dueling Excel podcasts between Bill Jelen and Mike Girvin! The challenges, the energy, the solutions, the community involvement…everything! Let’s look at **Excel duel 141** (the PI episode). The **best solution depends on asking one question**. Continue reading

# Posts Tagged → Mike Girvin

# My Favorite Excel Tips From Other Sites Part 2.

As much as I enjoy sharing my knowledge I have found that this series is just as beneficial for me as it is for others. I sometimes ask myself or others “Do you remember that Excel thing that does….” Continue reading

# Array Formula Examples

**Why do you use array formulas?**

**Why can’t we use a normal Excel function?**

**What does an array formula do?**

People often ask me questions like these. A quick answer is that **array formulas can be used to answer very complex questions about data**.

# Video 00043 Formulas_Array Formulas_Example1_LEN_function

**Question: Why use an array formula?**

**Answer: ****Because you can answer many complex questions using only 1 array formula!**

In this video, I use an array formula to extend the use of Excel’s LEN function. Continue reading