D
DamienO
Hi all,
I have rows of data being recorded for different dates. The number of data
points for each date changes (normally 1-4). Since I don't know in advance
how many data points will be recorded for each date I can't set-up an average
for each day.
Is there a way to find and list unique dates and then get an average of data
for each unique date?
(i.e. get an average of the 4 points for 12/01/10, 2 points fo 13th etc)
Col 2 col 3 col 4 col 5 col 6
col 7 col 8
Row 7 12/01/10 12/01/10 12/01/10 12/01/10 13/01/10 13/01/10 14/01/10
Row 9 12.3 13.1 12.9 13.0 8.1
8.5 6.5
I have rows of data being recorded for different dates. The number of data
points for each date changes (normally 1-4). Since I don't know in advance
how many data points will be recorded for each date I can't set-up an average
for each day.
Is there a way to find and list unique dates and then get an average of data
for each unique date?
(i.e. get an average of the 4 points for 12/01/10, 2 points fo 13th etc)
Col 2 col 3 col 4 col 5 col 6
col 7 col 8
Row 7 12/01/10 12/01/10 12/01/10 12/01/10 13/01/10 13/01/10 14/01/10
Row 9 12.3 13.1 12.9 13.0 8.1
8.5 6.5