compare arrays and add differences

[MSAZ11]

Does anyone know an Excel command to compare two or more arrays and identify differences to be reported back to a master sheet? I am trying to build a master customer table and then quantify revenue in annual tables by year in a master table. Please advise. Thank you so much.

[#2]

@MSAZ11 

Attached is an example file.

Maybe this will help you to get ahead in your project.

If not... just ignore it :).

Hope I was able to help you with this file.

NikolinoDE

I know I don't know anything (Socrates)

[#3]

@MSAZ11 

It very depends on which Excel version/platform you are.