summing values in a column largest first until i reach a certain value

[Nathan___Mox]

Hey all,

I need help with a problem

I have 4 columns one named supplier, one named group, one named year, and one named %. I'm trying to make a new column to sum from the largest % until it reaches 80%, and name the values inculded in the sum to 80% to be named yes, and all those that aren't included be named no. But I wan't this filtered by group and year.

Heres an example of just one group and year,

supplier	group	years	%	New Column
1	a	21	50%	yes
2	a	21	15%	yes
3	a	21	10%	yes
4	a	21	10%	yes
5	a	21	5%	no
6	a	21	5%	no
7	a	21	5%	no

Any help would be much appreciated, if you need anymore info let me know.

Thanks 

Nathan

[Ahmedx · Accepted solution]

pls try this
.8 = 0.8 = 80%
.9 = 0.9 = 90 %