Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Compare Columns
Is there a formula the counts the number of matches between two columns for
the same row? For instance 2 1 3 3 5 3 1 3 2 2 5 3 5 2 4 5 5 3 3 1 5 2 5 3 4 3 2 2 2 2 5 2 4 4 2 2 5 4 2 1 The formula should say 6 because there are matches in rows 2,5,14,15,17,18 -- jake |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Compare Columns
Try
=SUMPRODUCT(--(A1:A20=B1:B20)) -- Regards, Peo Sjoblom "Jakobshavn Isbrae" wrote in message ... Is there a formula the counts the number of matches between two columns for the same row? For instance 2 1 3 3 5 3 1 3 2 2 5 3 5 2 4 5 5 3 3 1 5 2 5 3 4 3 2 2 2 2 5 2 4 4 2 2 5 4 2 1 The formula should say 6 because there are matches in rows 2,5,14,15,17,18 -- jake |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Compare Columns
thank you
-- jake "Peo Sjoblom" wrote: Try =SUMPRODUCT(--(A1:A20=B1:B20)) -- Regards, Peo Sjoblom "Jakobshavn Isbrae" wrote in message ... Is there a formula the counts the number of matches between two columns for the same row? For instance 2 1 3 3 5 3 1 3 2 2 5 3 5 2 4 5 5 3 3 1 5 2 5 3 4 3 2 2 2 2 5 2 4 4 2 2 5 4 2 1 The formula should say 6 because there are matches in rows 2,5,14,15,17,18 -- jake |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compare two columns | Excel Discussion (Misc queries) | |||
Compare two columns | Excel Discussion (Misc queries) | |||
COMPARE 2 COLUMNS | Excel Discussion (Misc queries) | |||
Compare two columns | Excel Discussion (Misc queries) |