Top 5 from sub-array

[morsagmon]

Hi.

I have a table (PipelineTable) with these columns:
P
Amount

I need to extract the top 5 amounts from the rows that meet a criteria: P is a fraction (between 0 and 1).
For example, if this is the PipelineTable:

[TABLE="class: grid, width: 100, align: left"]
<tbody>[TR]
[TD]P[/TD]
[TD]Amount[/TD]
[/TR]
[TR]
[TD]0.5[/TD]
[TD]25[/TD]
[/TR]
[TR]
[TD]0[/TD]
[TD]50[/TD]
[/TR]
[TR]
[TD]0.75[/TD]
[TD]45[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]12[/TD]
[/TR]
[TR]
[TD]0.5[/TD]
[TD]20[/TD]
[/TR]
[TR]
[TD]0.75[/TD]
[TD]25[/TD]
[/TR]
[TR]
[TD]0.25[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]30[/TD]
[/TR]
[TR]
[TD]0.75[/TD]
[TD]12[/TD]
[/TR]
</tbody>[/TABLE]
















The top 5 results I'm after would be:
45
25
25
20
12

I'd prefer not to code a script for this and use a direct formula.
Using Array Formulas is fine if needed.

Thanks!
Mor

 

[morsagmon]

Thanks, Aladin!