Forum Discussion
compare arrays and add differences
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 Replies
It very depends on which Excel version/platform you are.
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.
I know I don't know anything (Socrates)
