Forum Discussion

Ethan Reid's avatar
Ethan Reid
Copper Contributor
Mar 07, 2018
Solved

INDEX MATCH MATCH Dynamic Named Lists

Hi everyone,   I am working on a report that needs to pull values found in a Pivot Table. The data in the spreadsheet must be displayed in a certain way to remain consistent with other corporate ...
Formulas & Functions
Need Help
  • Jamil's avatar
    Jamil
    Mar 07, 2018

    Can you at least repeat the data label in the pivot table?

     

    please see the animated gif on how to enable the setting of repeat data label in pivot table.

     

    If you can do that, then I may have a solution for you with formula.

     

    simply putting this formula in  J11 of the attached workbook and dragdown and right.

     

    Plz see it in the attached workbook.

     

     

    =IF(RIGHT($H11,5)<>"Total",SUMPRODUCT(($C$11:$E$29)*($C$10:$E$10=TEXT(J$10,"MMM YYYY"))*($A$11:$A$29=INDEX($H$11:$H11,MATCH(REPT("Ω",255),$H$11:$H11)))*($B$11:$B$29=$I11)),"")

     

    via GIPHY

Resources