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

5m Instrument	5m Max cm/s
AWAC	40
SD6000	32.02
SD6000	26.8
Aquadopp	41
SD6000	57.4
SD6000	41.2
SD6000	34.4
Aquadopp	22.5
Aquadopp	47.8

<tbody>
</tbody>

 

[Special-K99]

Does this work?

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

Array formula, use Ctrl-Shift-Enter