Calculations performed after sorting / finding the relevant data

[JennyReed]

Hi

I have a large amount of data that I would like to calculate percentiles on but need to extract the data belonging to the same instrument first.
How do I search for the instrument e.g. SD6000 and then perform the percentile calculation on only those values associated with that instrument
for example: SD6000 (calculation would be based on the values 32.02; 26.8; 57.4; 41.2 and 34.4).

I tried an IF function to 'find' the instrument (SD6000) but then did not know how to do the calculation (=percentile.inc(B2:B9,0.01)) on only the 'found' values.

Thank you,
Jenny

[TABLE="width: 181"]
<tbody>[TR]
[TD]5m Instrument[/TD]
[TD]5m Max
cm/s[/TD]
[/TR]
[TR]
[TD]AWAC[/TD]
[TD]40[/TD]
[/TR]
[TR]
[TD]SD6000[/TD]
[TD]32.02[/TD]
[/TR]
[TR]
[TD]SD6000[/TD]
[TD]26.8[/TD]
[/TR]
[TR]
[TD]Aquadopp[/TD]
[TD]41[/TD]
[/TR]
[TR]
[TD]SD6000[/TD]
[TD]57.4[/TD]
[/TR]
[TR]
[TD]SD6000[/TD]
[TD]41.2[/TD]
[/TR]
[TR]
[TD]SD6000[/TD]
[TD]34.4[/TD]
[/TR]
[TR]
[TD]Aquadopp[/TD]
[TD]22.5[/TD]
[/TR]
[TR]
[TD]Aquadopp[/TD]
[TD]47.8[/TD]
[/TR]
</tbody>[/TABLE]

 

[Special-K99]

Does this work?

=PERCENTILE(IF(A1:A9="SD6000",B1:B9),0.01)

Array formula, use Ctrl-Shift-Enter