Forum Discussion

Bianca Gordon's avatar
Bianca Gordon
Copper Contributor
Jan 17, 2018

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. 

Resources