Results 1 to 2 of 2

Thread: Unclear of how to enter formula

  1. #1

    Unclear of how to enter formula



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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.
    Attached Files Attached Files

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,491
    Articles
    0
    Excel Version
    Excel 2016
    Try something like:

    =B2/IFERROR(HLOOKUP(B$1,'Sheet2'!$3:4,2,0),1)

    This assumes the Pivot table dates start at a B1 and go across, and the row of values start in B2.

    Formula would go under the Pivot Table, in C2, here and copied across.

    Replace the Sheet2 name with actual sheet name of second sheet, and it assumes the data in that sheet are in rows 3 to 4.

    The IFERROR() part will return a 1 if the corresponding date is not found in the second sheet, which means the value will be divided by 1, leaving the result as shown in the PivotTable.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •