HOw to find the median of data that has two different criteria

[lewis54]

Hello, I have 3 columns. I need to find the medium of "Act. Life" for every time that specific "Item" matches with that specific "job".

Job	Item	Act. Life
B15000/693	C520230	340,547
B15000/595	C520230	247,426
B15000/595	C520230	543,333
B15000/857	C520230	313,274
B15000/693	C520230	228,299
B15000/595	C520230	252,808
B15000/693	C520230	161,436
B15000/693	C520230	646,656
B15000/693	C520230	336,319
B15000/595	C520230	109375
B15000/595	C520230	138,889
B15000/693	C520230	218,333
B15000/693	C520230	134,014
B15000/693	C520230	175,000
B15000/595	C520230	223,333
B15000/693	C520230	437,000
B15000/693	C520230	437,000

<tbody>
</tbody><colgroup><col><col><col></colgroup>

 

[pgc01]

Hi

You can use an array formula, like:

=MEDIAN(IF(A2:A18=Job;IF(B2:B18=Item;C2:C18)))

Replace Job and Item by their values

This is an array formula, you have to confirm it with CTRL-SHIFT-ENTER and not just ENTER.