# Calculations performed after sorting / finding the relevant data

#### JennyReed

##### New Member
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>

### Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

#### Special-K99

##### Well-known Member
Does this work?

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

Array formula, use Ctrl-Shift-Enter

Replies
12
Views
8K
Replies
0
Views
196