Forum Discussion
Bianca Gordon
Jan 17, 2018Copper Contributor
Formula that Compares Two Pivot Tables
Here's the Scenarios,
If any row in the first column of PivotTable1 equals any row in the first column of PivotTable2, then perform this formula (PivoTable1 Second column/ PivotTable2 Second column) for each row
I need to compare names between each pivot table then create a formula for the leads of these two names.
- Detlef_LewinSilver Contributor
Bianca,
please provide a sample workbook.