Hi there and welcome
To clarify, you want to see responses from clients seperared in months Mark?
ok... ill look at it and see what it is your asking for.
Attach it here via the paperclip.
ok, and this is what I initially asked Mark, what is it you want done in the yellow boxes?
Please remember I know nothing about this sheet, so please explain what you want there and from which data?
ok, sorry but its not very clear what you require. Its common as you know this sheet inside out.
Explain it like this.
What formula should be applied. Tell me this in your own words
eg: 40% of the letters sent out in October should be shown in September.
ok, so if you put in January =F4/F7
Then you get 15 showing 15% meaning 15% of the recipients replied.
Is this what you want?
No sorry I am not following what it is you want. I think its best I opt out and an expert that can better understand statistics as opposed to Excel can assist you. You do not need to do anything, you will be notified when a new expert picks up your case.
Sorry I could not solve this for you.
Hello. My name is***** will try to provide you with some additional assistance. In order to accomplish this, it needs to be boile down basically to an Excel formula which contains math and functions offered by Excel. Do you have an idea of what this formula will be? I'm referring to the formula in the predictive cells? As I'm sure you know it can't simply be predictive as there isn't a function that provides a predictive result – but if you could give a concrete example of what it would be in terms of and equation I should be able to help you get it into something Excel will understand.