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 2004 - 2007,
andrewsexceltips.com
. All Rights Reserved.