Forum Discussion
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 ...
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)),"")
Thank you for your response, although the formula was a bit confusing, it got the job done - you taught me a valuable tip on how to force the PivotTable to repeat name labels, that came in much more useful than you can imagine, thank you!
You are welcome. Thanks for your feedback.