Let me clarify, I'd like to avoid entering the formula in manually....this is
a "true" example of what I'm trying to convert, and would rather not enter
"1" 79 times, "2" 96 times, etc.:

Team # of
Size instances
1 79
2 96
3 110
5 78
6 62
7 47
8 50
9 32
10 43
11 28
12 26
13 28
14 16
18 7
19 7
20 6
23 4
24 2
26 1
27 1
30 1
32 1
39 1
17 14
4 76
15 16
22 3
16 17
25 1
38 1
31 1
34 1
21 3
33 1


"lisab" wrote:

Hello,

I want to find a median for team size with data that is currently set up in
the following manner:

Team size # of instances
20 3
9 1
8 2

Is there an easy way to convert the information so that I can use the median
function?
Thanks.
I n