MagsinoAS13
New Member
- Joined
- Jul 9, 2018
- Messages
- 6
Please help me look for a formula to get the maximum and minimum value based on certain criteria.
Thanks.
<tbody>
</tbody>
Result:
<tbody>
</tbody>
Criteria: Sent value should be more than 1,000 then I need to get the max and min value. In this case, we have 4 rows with more than 1000. And the Min is 41.86% and 56.69%.
However, If the sent has no value that is more than 1000, then we just get the Max and Min values, 80.00% and 41.86%.
Thank you so much.
Thanks.
Client | Campaign | Sent | Unique Opens | Opens rate |
Product1 | Campaign1 | 20 | 14 | 70.00% |
Product1 | Campaign2 | 18 | 11 | 61.11% |
Product1 | Campaign3 | 10 | 8 | 80.00% |
Product1 | Campaign4 | 9 | 6 | 66.67% |
Product1 | Campaign5 | 5172 | 2140 | 41.86% |
Product1 | Campaign6 | 129 | 85 | 65.89% |
Product1 | Campaign7 | 5 | 3 | 60.00% |
Product1 | Campaign8 | 13028 | 7061 | 55.16% |
Product1 | Campaign9 | 9407 | 5234 | 56.69% |
Product1 | Campaign10 | 1072 | 536 | 52.09% |
<tbody>
</tbody>
Result:
Client | Sheet | Min Open | Max Open |
Client Name1 | Product1 | 41.86% | 56.69% |
Client Name2 | Product2 |
<tbody>
</tbody>
Criteria: Sent value should be more than 1,000 then I need to get the max and min value. In this case, we have 4 rows with more than 1000. And the Min is 41.86% and 56.69%.
However, If the sent has no value that is more than 1000, then we just get the Max and Min values, 80.00% and 41.86%.
Thank you so much.