Welsh Mark3
Board Regular
- Joined
- Apr 7, 2014
- Messages
- 164
- Office Version
- 365
Month | Value | Desired Result |
1 | 10 | 20 |
1 | 20 | 20 |
2 | 20 | 50 |
2 | 50 | 50 |
3 | 150 | 150 |
3 | 5 | 150 |
<tbody>
</tbody>
I am treying to write a formula that finds the maximum value in a given mnmth. The table attempts to show what i am trying to do, the desired result is the value i am trying to produce.