MagsinoAS13
New Member
- Joined
- Jul 9, 2018
- Messages
- 6
Please help me look for a formula to get the Max and Min value based on given criteria.
<tbody>
</tbody>
RESULT
<tbody>
</tbody>
Criteria: The sent must be higher than 1000 to get the Max and Min Open Rate. In the example above, there are 4 rows with more than 1000 sent. So the Max Open Rate is 56.69% and Min Open Rate is 41.86. If the Sent column has no value higher than 1000, just get the normal Max and Min. In this case, Max is 80% and Min is 41.86%.
Any help is very much appreciated.
Thanks.
Client | Campaign Name | 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: The sent must be higher than 1000 to get the Max and Min Open Rate. In the example above, there are 4 rows with more than 1000 sent. So the Max Open Rate is 56.69% and Min Open Rate is 41.86. If the Sent column has no value higher than 1000, just get the normal Max and Min. In this case, Max is 80% and Min is 41.86%.
Any help is very much appreciated.
Thanks.