Generating a RANKING based on a criteria, HELP!

[juajar]

Hi, I have some data which looks like this:

Indice de Deuda Privada V3.01.xls
	A	B	C	D
9	CanastaMes
10
11	Rank	Percentage	Code	Issuer
12	1	15.88%	BCCB1059AV	CEMENTOSCARIBE
13	2	10.09%	BISA3049V	ISAINTERCONEXIONELECTRICA
14	3	9.21%	BAAA1039V	SOC.ACUED.B/QUILLA
15	4	6.82%	BDVT10230915	BOGOTAD.C.
16	5	6.47%	BIFC104AV	COR.FI.INTERNACIONAL
17	6	4.56%	BDIT04230909	BOGOTAD.C.
18	7	4.11%	BCMT07290110	COMCEL
19	8	3.94%	BISA1049V2	ISAINTERCONEXIONELECTRICA
20	9	3.60%	BISA1049V1	ISAINTERCONEXIONELECTRICA
21	10	3.40%	SAUTBOGIRA	FID.AUTOPISTABOGOT-GIRARDOT
DATOS

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%.

Thanks in advance for all your help

 

[juajar]

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

 

[West Man]

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

 

[West Man]

juajar
My apologies for an incomplete answer. See the edited answer above.

 

[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

 

[West Man]

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

 

[Aladin Akyurek]

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

Book2
	B	C	D	E	F	G	H
9					50%
10					6
11	Percentage	Code	Issuer		Percentage	Code	Issuer
12					0.1588	BCCB1059AV	CEMENTOS CARIBE
13					0.1009	BISA3049V	ISA INTERCONEXION ELECTRICA
14					0.0921	BAAA1039V	SOC. ACUED. B/QUILLA
15					0.0682	BDVT10230915	BOGOTA D.C.
16					0.0647	BIFC104AV	COR. FI. INTERNACIONAL
17					0.0456	BDIT04230909	BOGOTA D.C.
18
19
20
21
22
DATOS

F10:

=MATCH(TRUE,SUBTOTAL(9,INDIRECT(ADDRESS(ROW(B12),COLUMN(B2))&":"&ADDRESS(ROW(B12:B21),COLUMN(B12:B21))))>=F9,0)

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)),"")