# 8 Formulas to get Unique Count Across Rows in Excel (Part 1/3)

## 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?

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!

Move on to PART 2 to learn about the MMULT formula

Move on to PART 3 to learn about the MMULT formula

You’d like to try it yourself? Download the file here. Let me know what you come up with!

# 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.

### One Comment

1. […] 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 […]