Difficult Question about averages... Possibly Nested loops...
To me it would be easier if you redesign you structure so you were adding
records rather than fields.
User DateIn Usage
Mike 23/04/2007 41
Mike 24/04/2007 52
....etc
You can then SUMIF, COUNTIF, AND etc or SUBTOTALs etc to get the
data/report.
You could also use SQL to query it.
NickHK
"Janos" wrote in message
...
Hello,
I don't know if this is reallya difficult question, but its got me
stumped.
What I am trying to achieve is to calculate a monthly average for
individual
users. There is a table that looks like this:
User 23/04/2007 24/04/2007
Mike 41% 52%
Micheal 39% 45%
Jason 58% 55%
The first column contains the user in question, and the subsequent columns
the data for each day. The result is that all the data for one user is in
one
row. The only (big) problem is that new columns of data will be added on a
daily, or quasi daily basis. This implies that i don't know how many
columns
would be added for one particular month (so, no predifined spacings for
the
calculations). The averages per user need to be calculated and formatted
in
the following format:
User April May
Mike 40% 45%
Micheal 30% 50%
Jason 50% 40%
I couldn't for the life of me think of a way to do this with a worksheet
function, and other than a hunch of needing nested loops or doing one loop
per month per user, I'm stumped.
Any help would be greatly appreciated!
Thanks,
Janos
|