Median problem

[MasmaAbdulhamidli]

Hi. I have large database and i have to find median of only selected cells. I filtered and used Median formula but it is not give correct. Then i tried Aggregate (=AGGREGATE(12;1;etc) formula but now when i unfiltered all data changed. Can you help me?

 

[AhoyNC]

It would help if you could post a small sample of your data.
Maybe try something like below.
This is an array formula and must be enter with CTRL-SHIFT-ENTER (not just ENTER).

Book1
	A	B	C	D	E
1
2	A	30		Median of:
3	B	38		A	36.5
4	A	39
5	C	29
6	D	18
7	A	23
8	B	63
9	C	19
10	A	36
11	D	54
12	A	55
13	A	37
Sheet2

Cell Formulas
Range	Formula
E3	E3	=MEDIAN(IF($A$2:$A$13=D3,$B$2:$B$13))
Press CTRL+SHIFT+ENTER to enter array formulas.