Nebula2121
New Member
- Joined
- Apr 1, 2016
- Messages
- 32
A | B | C | |
1 | Name | Value | Result |
2 | Apple | 5 | 7 |
3 | Broccoli | 10 | 12 |
4 | Broccoli | 1 | 0 |
5 | Apple | 2 | 0 |
6 | Broccoli | 1 | 0 |
7 | Pear | 5 | 0 |
<tbody>
</tbody>
How do I set up an excel formula for the desired result in Column C? I would like the sum of value for each name to show up once and only have the largest 2 result present. I can do this easily with a pivot, but can't figure out the formula. Thanks!
Last edited: