zanderaruba
New Member
- Joined
- Jun 29, 2012
- Messages
- 21
Hey guys,
I am looking to calculate the average within a certain quartile within a large data set. However, rather than just taking the average of the quartile of all my data, I want to also subject the formula to another condition.
For example, I have a set of $ values in column A. I then have a set of either “1” or “0”s in Column B. I would like to take the average of all the dollar values in Column A that have a 1 as their value in Column B and fall within the top quartile of those specific rows.
Can anyone help me out with a formula that could be used to accomplish this? Thank you
I am looking to calculate the average within a certain quartile within a large data set. However, rather than just taking the average of the quartile of all my data, I want to also subject the formula to another condition.
For example, I have a set of $ values in column A. I then have a set of either “1” or “0”s in Column B. I would like to take the average of all the dollar values in Column A that have a 1 as their value in Column B and fall within the top quartile of those specific rows.
Can anyone help me out with a formula that could be used to accomplish this? Thank you