Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formula to Look up values from a pivot table
Hello,
Could you please suggest a formula to look up values from a pivot table without altering the structure of the pivot table ? PLease refer below attachment If u suggest SUMPRODUCT, I would like to mention the pivot table keeps growing month by month, and as it gets bigger, it takes lot of time for excel to derive values and sometimes it stalls the workbook Thanks |
#2
|
|||
|
|||
Any help please ?
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Max Values in Pivot Table | Excel Discussion (Misc queries) | |||
Pivot table values | Excel Discussion (Misc queries) | |||
Copying values from pivot table to cells outside pivot table | Excel Discussion (Misc queries) | |||
formula to get values from pivot table | Excel Worksheet Functions | |||
Why won't pasted values from a formula appear in a pivot table | Excel Discussion (Misc queries) |