Hello All,
if i have two pivot tables with multiple column, how to compare and find out records in one of the column for specific row has been changed? any quick technique ?
Regards
how to compare two pivot tables?
-
- BronzeLounger
- Posts: 1268
- Joined: 01 May 2016, 09:58
-
- Administrator
- Posts: 78631
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: how to compare two pivot tables?
Do the two pivot tables have exactly the same layout?
Best wishes,
Hans
Hans
-
- BronzeLounger
- Posts: 1268
- Joined: 01 May 2016, 09:58
Re: how to compare two pivot tables?
yes they have
attached is a sample data, for two sheets with the same table layoutYou do not have the required permissions to view the files attached to this post.
-
- Administrator
- Posts: 78631
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: how to compare two pivot tables?
See the attached workbook.
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans
Hans
-
- BronzeLounger
- Posts: 1268
- Joined: 01 May 2016, 09:58
Re: how to compare two pivot tables?
thank you for the reply,
what i want is : for example for user01 , i want to check if the numbers in the 4 column next to it is changed or it is same?
what i want is : for example for user01 , i want to check if the numbers in the 4 column next to it is changed or it is same?
-
- Administrator
- Posts: 78631
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: how to compare two pivot tables?
Here is an attempt using conditional formatting.
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans
Hans
-
- BronzeLounger
- Posts: 1268
- Joined: 01 May 2016, 09:58
Re: how to compare two pivot tables?
wow very good thank you very much as usual it works as expected.
-
- BronzeLounger
- Posts: 1268
- Joined: 01 May 2016, 09:58
Re: how to compare two pivot tables?
Dear Hans,
thank you for the sample file, I appreciate if you explain a bit how did you apply the conditional formatting for learning purpose.
Regards
-
- Administrator
- Posts: 78631
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: how to compare two pivot tables?
This is the conditional formatting rule on Sheet1:
Clicking Edit Rule... results in
The rule is applied to B2:E8, and the formula in the box shows what it looks like for the top row. Since the row reference in $A2 is relative, Excel will use $A3 in row 3, $A4 in row 4 etc. The column reference is absolute, so the rule will always look at the cell in column A.
The formula looks up the value of the row label on the other sheet and returns the corresponding value from the appropriate column.
The cell is highlighted if that value is different from that of the cell.
Clicking Edit Rule... results in
The rule is applied to B2:E8, and the formula in the box shows what it looks like for the top row. Since the row reference in $A2 is relative, Excel will use $A3 in row 3, $A4 in row 4 etc. The column reference is absolute, so the rule will always look at the cell in column A.
The formula looks up the value of the row label on the other sheet and returns the corresponding value from the appropriate column.
The cell is highlighted if that value is different from that of the cell.
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans
Hans
-
- BronzeLounger
- Posts: 1268
- Joined: 01 May 2016, 09:58
Re: how to compare two pivot tables?
Thank you very much dear Hans, much appreciated.
Regards
Regards