Hi

Please can anyone let me know what the formula would be to let me know the
median of a range of numbers depending on the types - ie

Type Number
Distribution 1
Distribution 1
Distribution 2
Distribution 2
Distribution 3
Distribution 4
Distribution 5
Marketing 1
Marketing 2
Marketing 3
Marketing 3
Marketing 4
Sales 1
Sales 2
Sales 2
Sales 2
Sales 2
Sales 3
Sales 4
Vending 2
Vending 2
Vending 3
Vending 3
Vending 3
Vending 5

What I need to do - as my data is rather more than the example and will not
be sorted as above - is show the median for Sales & Distribution would be 2
and Vending & Manufacturing 3.

Please advise and thanks for your time

Pen