Calculations performed after sorting / finding the relevant data

JennyReed

New Member
Joined
Feb 8, 2011
Messages
23
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 Instrument5m Max
cm/s
AWAC40
SD600032.02
SD600026.8
Aquadopp41
SD600057.4
SD600041.2
SD600034.4
Aquadopp22.5
Aquadopp47.8

<tbody>
</tbody>
 

Some videos you may like

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
Joined
Nov 7, 2006
Messages
8,348
Does this work?

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

Array formula, use Ctrl-Shift-Enter
 

Watch MrExcel Video

Forum statistics

Threads
1,108,509
Messages
5,523,313
Members
409,511
Latest member
hitesh222002

This Week's Hot Topics

Top