# Generating a RANKING based on a criteria, HELP!

#### juajar

##### New Member
Hi, I have some data which looks like this:

Is is a rank and is ordered by percentage in descending order. What I want to do is generate a new list below it which only puts the ones until the total is over 50%. In other words, I JUST want the rows below and inlucing the one which makes the total go over 50%.

### Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type
One more thing

I would like for it to be a new list with only the ones that meet the criteria, not filter the same list.

Thanks

Here is one way:
In E6 and drag down through E15 =Sum(E\$6:E6)

In cell A18
=IF(\$A6<=MATCH(VLOOKUP(0.5,\$E\$6:\$E\$15,1,1),\$E\$6:\$E\$15)+1,A6,"")

Drag across and down

juajar

Not working

Thanks for your reply, I can´t seem to get the formula to work. It references some cells that are no on the example.

Thanks

Again, my apologies. I have edited my reply. Try the new version.

Re: One more thing

I would like for it to be a new list with only the ones that meet the criteria, not filter the same list.

Thanks

F10:

which is confirmed with control+shift+enter, not just with enter.

F12, copied across then down:

=IF(ROWS(F\$12:F12)<=\$F\$10,INDEX(B\$12:B\$21,ROWS(F\$12:F12)),"")

Replies
2
Views
144
Replies
13
Views
445
Replies
0
Views
164
Replies
3
Views
356
Replies
2
Views
264

1,206,949
Messages
6,075,811
Members
446,158
Latest member
octagonalowl

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back