Please see the attachment. What I need to do is match the date from the pivot table (some of the dates may be skipped) to the date on the other sheet.
Then, I need to calculate the number under the date on the pivot table divided by the number under the date on the next sheet, and have it show. Someone has previously posted a formula, but I don't understand how the formula was entered. For example, under 20140808, I need to divide 85.6 by 72, and have the calculation show right under the 85.6. Is that doable?
Anyone able to help?
Thank you.
Then, I need to calculate the number under the date on the pivot table divided by the number under the date on the next sheet, and have it show. Someone has previously posted a formula, but I don't understand how the formula was entered. For example, under 20140808, I need to divide 85.6 by 72, and have the calculation show right under the 85.6. Is that doable?
Anyone able to help?
Thank you.