HELP! I need to compare two sets of numbers as follows:
Numbers are entered into A1:A10 (input set).
Existing sets of numbers are in D7:H7 (set-1) and D8:H8 (set-2).
I need to compare the numbers in sets 1 & 2 and count the number of numbers that match those in the input set.
For example:
input set = 12, 16, 65, 5, 95, 21, 3, 74, 41, 10
Set-1 = 21, 49, 74, 32, 16 count = 3 (21, 74 & 16 match)
Set-2 = 88, 95, 7, 65, 38 count = 2 (95 & 65 match)
The 'count = ' numbers are the ones that I need to calculate. Is there any formula that I can use to figure this?
Thank you,
Mike
Bookmarks