Hi,
I have the following data. I'm trying to select the number based on a group threshold of 80. So I basically have to select the highest number within the group to make the group total to be under the group threshold of 80. Is there a way to do that with the formula tool? or other tools?
| Group | Number | Select | Not Select | Each Group's Total (currently) |
| A | 10 | | | 150 |
| A | 30 | | |
| A | 40 | | |
| A | 50 | | |
| A | 20 | | |
| B | 90 | | | 135 |
| B | 10 | | |
| B | 15 | | |
| B | 20 | | |
| C | 40 | | | 210 |
| C | 50 | | |
| C | 20 | | |
| C | 100 | | |
Thanks for your help!! Much appreciated.
