Hi!

I have a table of data:
column A: dates
column B: values

I want to know the average value over a certain period
however, for some dates I have more values than for others, which makes that
a classic average would give a distorted picture, very much like a wighted
average, which i don't want

eg.
13-Jun-02 8250
22-May-02 8400
16-May-02 8750
15-May-02 8000
12-Apr-02 8000
28-Mar-02 8300
22-Mar-02 8250
22-Mar-02 7750
08-Mar-02 8500
01-Mar-02 8250
26-Feb-02 7500
20-Feb-02 8400
05-Feb-02 6800
05-Feb-02 7000

I understand that the solution might take more than one step as if more that
one value corresponds with 1 single day, first an average should be
calculated? or not?
is there a single formula covering this request?

thanks in advance!
tom