If this is for recording blood glucose
readings, I have a spreadsheet that is designed to do this. If you
want me to send it to you directly let me know.
Joe Conner, Poulsbo, WA 98370 USA
James Elliott wrote:
I
have a Calc spreadsheet (OOo 2.0; Win XP) which has a column of dates
and a column of data readings. Sometimes there are three readings on
the same day. This is what it looks like:
17/02/06 7.9 (@ 1300 hrs)
17/02/06 5.4 (@ 1500 hrs)
17/02/06 9.9 (@ 1700 hrs)
18/02/06 6.7 (@ 1300 hrs)
18/02/06 8.0 (@ 1500 hrs)
18/02/06 7.1 (@ 1700 hrs)
19/02/06 4.4 (@ 1300 hrs)
19/02/06 6.7 (@ 1450 hrs)
19/02/06 5.2 (@ 1800 hrs)
I want to:
1. average these results
2. report the number of data points (readings)
3. report the number of days over which readings were taken.
I can get the average by using the AVERAGE function.
I can get the number of readings by using the COUNT function.
... but, how do I get the number of days?
If I use the CountA function it returns 9 days when readings were
recorded clearly over only 3 days.
What I need is something like a COUNT-DISTINCT function.
Can anyone help with a solution to this question.
Many thanks, James Elliott
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
|
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
