3 month average

[cape]

"Need to get 3 month average
Like match A D G and get 3 month average from B E H" A D G are tech numbers (people) B E H are the actual numbers that I need to be averaged out. Some (people) don't have a full three months. So I would like to average for two or just put in the one month they may have worked

[Richard Buttrey]

Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.

Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.

In addition, please add a Location to your profile. It is often useful to know this when data/time arithmetic is involved or regional settings for stuff like list separators etc are relevant.

[cape]

The paper clip is not working on my end.


June FCR July FCR August FCR "Need to get 3 month average here
match A D G and get 3 month average from B E H In some instances there will not be all 3 B E H

Sales Id FCR% Sales Id FCR% Sales Id FCR%
21614 100.00 21614 89.66 16158 86.36
37279 79.41 32517 83.33 32517 94.34
37442 92.86 35235 94.37 35235 98.57
38523 87.50 37442 89.39 37279 96.08
50539 91.49 38523 90.63 37442 87.10
51638 96.97 50539 89.23 38523 86.05
52722 91.55 51638 92.98 50539 93.44
57044 89.66 52722 90.70 51638 95.65
58732 88.31 57044 86.02 52722 96.15
59740 94.59 58732 90.29 57044 94.81
60439 93.88 59740 81.58 58732 89.06
61728 94.44 61728 86.96 59740 93.55
65778 92.31 65778 89.29 61728 91.30

Capture.JPG

[cape]

Attached file Hopefully it worked. And Thanks in advance

[Richard Buttrey]

Does that workbook contain the results which you expect, (see post #2) and if so please explain how you have calculated them. i.e. which cells you have used.