Forum Discussion
Parisa20000
Aug 27, 2022Copper Contributor
How to compare different pivots in two different excel workbook? Urget help
Hi I really need help... I have received two excel workbooks that pivot tables not the raw data for sheets my task is to compare the numbers of two excels(pivots) I tried to do it by ctrl-a sele...
SergeiBaklan
Aug 27, 2022Diamond Contributor
Afraid not, it's better to compare data sources
Parisa20000
Aug 27, 2022Copper Contributor
Thanks. How can I compare 2 different excel workbooks? with huge data
but they don't have the same row or column
only some similarities
with lots of hierarchy
- SergeiBaklanAug 27, 2022Diamond Contributor
Power Query could work, but it's hard to say not seeing the sample
- Parisa20000Aug 27, 2022Copper ContributorCan you please show me How to compare two excel files in which rows and columns are not the same?