Seeking for best practices / tips comparing two large data arrays from two different workb

Perhaps you could supply some data that shows what you begin with data wise, & then what you are expecting as a result.

Originally Posted by johnnyL

Perhaps you could supply some data that shows what you begin with data wise, & then what you are expecting as a result.

Greatly appreciate your valuable tips

You still haven't said/shown what you expect the outcome to be.

Just need to make sure all the numbers are the same for each country wise and level wise between the two workbooks, let me know if this answer your question

You are still being very vague.

What are the name of the workbooks, are they both open, or do they need to be opened?
What are the name of the sheets that are involved?
Do both the sheets contain the same number of rows?
Are the rows of data in both the sheets in the same order? In other words Should row 2 on one sheet match row 2 on the other sheet?
What do you want to happen if there is a mismatch?
Do all columns of data have to match for each row?

Providing more details will possibly yield more responses from the members here.

Thanks for response.

I have checked google and youtube, and also asked chatgpt. I am definitely not ready for VBA yet, and power query seems requires more steps than the method below.

so what I am doing in steps are:
1. create two pivot tables from two different workbooks,
2. sort the rows in both pivot tables
3. copy both pivot tables into one sheet
4. use (example) =if(a1=m1, "-","no")