Compare Lists 1

To count the same entries in 2 lists of the same size

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

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

or

{=SUM(1*(A1:A10=B1:B10))}

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



© Copyright andrewsexceltips.net All Rights Reserved.