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 |
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) |