I have a large set of data from which I am trying to generate information. I am having difficulty with the following example (obviously my data set is much larger than this):
<tbody>
</tbody>
What I am trying to do is make a function that will determine how many different favorite colors there are for people who have X amount of pets. For example, there are 2 different favorite colors for people who own 3 pets.
Since my data set is large, I would like to create a formula that can do this over a ~5000 rows.
Thanks
Name | Favorite Color | # of Pets |
Joe | yellow | 4 |
Kelly | green | 3 |
David | green | 3 |
Richard | orange | 2 |
Vicki | blue | 3 |
<tbody>
</tbody>
What I am trying to do is make a function that will determine how many different favorite colors there are for people who have X amount of pets. For example, there are 2 different favorite colors for people who own 3 pets.
Since my data set is large, I would like to create a formula that can do this over a ~5000 rows.
Thanks