**You’ll learn 3 of them in this video!**

**Learn Excel Array formulas by going through the example**

While I solve this problem, I also explain how array formulas work in Excel. They can be difficult to get the hang of. This video shows you how I approach complex problems. I hope I managed to explain it in simple terms.

You’ll learn a simple method to create complex formulas.

**Before watching the video, try solving it yourself. Here is the deal:**

You need to find a formula that solves the below problem:

**The tricky part is this:**

If B, D or R win a price, the workshop (i.e. that row) counts as 1. This means if we only had data until row 10, we need to get 4 as our answer! (…the data set is bigger than this…)

**How would you go about it? **Use intermediate steps? Use one formula?

You can download the file below:

Don’t watch the video until you attempt it yourself…

…then you can see how I tried to solve it with 1 Array Formula.

p.s. Honestly I shot this video over 10 times! It was originally intended to be 1 video, showing 1 solution, but every time I started editing the video, I came up with new formulas that could do this, so I kept shooting it over and over again with different solutions and finally it became a three series video. Hope you enjoy it and learn more about Excel array formulas!

## Download the Workbook Below…

# The new Excel Dashboards course is here!

## Now available on Udemy

Visually Effective Excel Dashboards for your reports.

Redeem your coupon for 75% off below.

Learn to use MMULT Function in Excel using Simple Steps |January 23, 2017 at 4:53 pm[…] formula, MMULT function to solve complex problems. I will use the same example as the last post to get unique count across rows. The tricky part here is: We nee to get unique count across […]