Ask Mac Questions and Get Answers from Experts ASAP
Could you please send me the file so I can take a look at it (let me know if you are not familiar with sending files on this site)
Ok, go to www.wikisend.com and upload the file there (no need to sign up). You will then get a page that has the download link and File ID. Copy the download link or the File ID and come back here and paste it in your reply.
Please make sure you identify the cells in question and where you want the formulas or result to be placed
Sure, take your time
Yes I got the file and I am looking at it now
It is clear which row is coming from which row, but what data will each cell in the row pull from the other row? Say E63 and F63, what will they pull from row 52
Not fully. I gave two examples. Quarter? would that be current quarter, which is month 1 thru 3?
Thanks I think it is clear for the most part (where does '2 year data' come from if there are only 13 months)?. That means 35 unique formulas are needed none of which can be simply copied and pasted to another cell. If it were one or two unique formulas I would be happy to write them for you. Under the circumstances I am going to opt out so the question becomes open to all experts. The clarification that you provided will be available and will certainly help the other experts
Thanks. I guess I will have to continue assisting with this. Not a problem, I will set up a few formulas and send them out to you for your review, then we will take it from there.
Ok here are most of the formulas (except for the 2-Yr part). As you will notice I had to use some helper columns (BA through BF) to hold some transitional formulas.
Hope this is ok