How can I select the item based on the group threshold?

[calvinwong]

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.

[calvinwong]

Hi @tcroberts,

Thank you. Everything worked now. :)