Comparing Two Tables

Lets suppose you have two tables of information and you want to compare the values to see how many match.

The formula in cell "E13" loops through all the cells in the range and compares each element using the IF function.
The results from this are then passed as an array to the SUM function.
Both the ranges must contain the same number of elements, otherwise an error will be returned.



© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited TopPrevNext