Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Difficult Question about averages... Possibly Nested loops...
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Nested hlookup/vlookup (possibly just an if statement though?!?) | Excel Discussion (Misc queries) | |||
Many Nested loops | Excel Programming | |||
nested for loops and end for | Excel Programming | |||
Problem with data using IF and Nested IF statements possibly??? | Excel Discussion (Misc queries) | |||
Help on nested loops | Excel Programming |