Compare Lists 2

To count different entries in 2 lists of the same size

{=SUM(IF(A1:A10=B1:B10,0,1))}

Push Ctrl, Shift and Enter to make this an array formula

or

=SUM(1*(A1:A10<>B1:B10))

If any of the above formula returns 0, then boths list are identical



© Copyright andrewsexceltips.net All Rights Reserved.