Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Another related question to averaging previous values
Still the same table as previous but with an additional col which is now
colA. ColA makes a 3-month analysis to the data such that now I would like to find the mean of still the previous 6 months but "previous" based on colA not on colB but still using the monthly numeric values in colB, just that the definition of previous has changed, such that the average of previous six months for cell D1 would be 1930jul,aug,sep,oct,nov,dec, cell D2 1930oct,nov,dec,1931jan,feb,mar, cell D3 1931jan,feb,mar,apr,may,jun and so on until we get to end. I do have monthly values (in colB) prior to 1931jan I thought putting them in doesn't look neat and may cause confusion. Over to you with my many thanks for your help. colA colB colC colD 1931jfm 1931jan 2 D1=mean previous 6 values based on A(1930j,a,s,o,n,d) 1931amj feb 3 D2=mean (1930o,n,d,1931j,f,m) 1931jas mar 4 D3=mean (1931j,f,m,a,m,j) 1931ond ... .. 1932jfm .... .. ..... .. 1976ond 1976dec 5 Speedy |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Another related question to averaging previous values
Probably my question is not clear so I'm trying to post it again. I have 3
cols such that they look like this: colA colB colC colD 1931jfm 1931jan 1 mean of 1930(j,a,s,o,n,d) 1931amj 1931feb 2 mean of 1930(o,n,d),1931(j,f,m) 1931jas 1931mar 3 .... 1931ond 1931apr 4 ..... where j is jan, f is feb, m is march and so on 1930(j,a,s,o,n,d) is jul1930, aug1930,sep1930 and so on till dec1930 I want to calculate the mean of the previous 6 months which is to become colD. Because the columns are so long and many of them it's hard to do it manually. Many thanks again Speedy ________________________ "Speedy" wrote: Still the same table as previous but with an additional col which is now colA. ColA makes a 3-month analysis to the data such that now I would like to find the mean of still the previous 6 months but "previous" based on colA not on colB but still using the monthly numeric values in colB, just that the definition of previous has changed, such that the average of previous six months for cell D1 would be 1930jul,aug,sep,oct,nov,dec, cell D2 1930oct,nov,dec,1931jan,feb,mar, cell D3 1931jan,feb,mar,apr,may,jun and so on until we get to end. I do have monthly values (in colB) prior to 1931jan I thought putting them in doesn't look neat and may cause confusion. Over to you with my many thanks for your help. colA colB colC colD 1931jfm 1931jan 2 D1=mean previous 6 values based on A(1930j,a,s,o,n,d) 1931amj feb 3 D2=mean (1930o,n,d,1931j,f,m) 1931jas mar 4 D3=mean (1931j,f,m,a,m,j) 1931ond ... .. 1932jfm .... .. .... .. 1976ond 1976dec 5 Speedy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
date related question??? | Excel Worksheet Functions | |||
practical business related question, IF, LOOKUP...? | Excel Discussion (Misc queries) | |||
Another Date related question.... | Excel Worksheet Functions | |||
Summing Related Values | Excel Discussion (Misc queries) | |||
Function Related Question | Excel Discussion (Misc queries) |