Welcome Guest. Sign in or Signup

1 Answers

How do I identify differences between two lists?

Asked by: 1480 views Microsoft Office, resolved

I have two lists of different lengths and want to show the differences without regard to case.

1 Answers



  1. Solution Center on Sep 25, 2012

    In Excel, put one list in column A and the other in column B. In column C paste this formula:
    =IF(ISERROR(MATCH(B1,A:A,0)),”NO MATCH”,””)
    Copy down this formula to meet the length of column B (CTRL+D). To sort, copy and paste column C to column D, but use Paste Special >> Values and Number Format. Then you can sort on column D.


Answer Question