Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |