Garvey1973
New Member
- Joined
- Nov 18, 2015
- Messages
- 8
I am trying to find the largest number based on the date, then quantity on trade for each day of the month. I currently do it manually each day but am looking for a formula to do it for me without using the ctrl+shift+enter function. Looking for the formula in largest trade column
<tbody>
</tbody>
Any help would be appreciated.
Date | Quantity | Quantity on trade | Largest trade |
1/1 | 3 | 3 | |
1/1 | 9 | ||
1/1 | 14 | 23 | 23 |
1/2 | 10 | ||
1/2 | 10 | 20 | |
1/2 | 32 | ||
1/2 | 8 | 40 | 40 |
1/3 | 7 | ||
1/3 | 4 | ||
1/3 | 3 | 14 | |
1/3 | 7 | 7 | |
1/3 | 11 | 11 | 14 |
<tbody>
</tbody>
Any help would be appreciated.