Dynamic comparison and mergeing of ranges and arrays
Efficient ways of dynamically merging and reconciling lists of data.
MATCHES - Join 2 arrays or ranges together on matching key columns
MISSMATCHES - Find the missmatched rows using key columns (Anti-Join)
COMPARE.LISTS - Very efficient comparison of two arrays or ranges
|