Search code examples
excelexcel-formulastring-comparisonworksheet-functioncountif

Compare two columns of words

I have two columns in Excel:

**A1:A300**            **C1:C300**         

    ABBEY               3i Group PLC
    ABN AMRO            3M Co.  
    ACCOR               A2A SpA 
    ACKERMANS           AREAL BANK  
    ...                 ABB     
                        Abbey National  
                        ...

Is it possible to compare these for repeated words?

Solution

  • Try: 

     =COUNTIF(C$1:C$300,A1)

    in Row 1 and copied down to suit.

    The result should be the number of times the A column value for the corresponding row features in Column C.

    ABBEY would not 'match' with ABBEY NATIONAL.