Hi,

I need to create an array in VBA and then perform a MEDIAN function on
it.

The data in the sheet which will be used to create the array is as
follows:

A B
2 1
3 2
1 3
2 4
3 5

Column B refers to a VALUE, Column A refers to the COUNT of the number
of instance of that value in the desired array.

ie the array (1-dimensional list really) actually looks like:

1
1
2
2
2
3
4
4
5
5
5

What i am trying to do is create a FUNCTION which uses the ranges in
columns A&B to create this array and the return the MEDIAN of the array
back (in this small example, the MEDIAN is 3).

Any ideas please?

Thanks in Advance,

Tigpup