Aug 27 2022 01:07 AM
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 selecting everything and paste as a value
but the data is huge my laptop is not ok with it.
is there any solution to compare these two huge pivot tables without having raw data of sheets....
if yes? how?
Aug 27 2022 06:08 AM
Afraid not, it's better to compare data sources
Aug 27 2022 07:09 AM
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
Aug 27 2022 08:45 AM
Power Query could work, but it's hard to say not seeing the sample
Aug 27 2022 08:51 AM