Compare two lists online

    how to reconcile two lists in excel
    how to compare two lists in excel for duplicates
    how to compare two lists in excel using vlookup
    how to combine two lists in excel
  • How to reconcile two lists in excel

    • How to compare two data sets in excel for matches.

    How to cross reference two lists in excel in two different sheets

  • How to cross reference two lists in excel in two different sheets
  • Vlookup to compare two lists
  • How to compare two data sets in excel for matches
  • How to compare two lists in python
  • Compare two lists for matches

    • Compare Two Lists in Excel

    This page describes how to compare two lists in Excel using conditional formatting and COUNTIF. For example, let's compare two lists of NFL teams.

    To highlight the teams in the first list that are not in the second list, execute the following steps.

    1.

    First, select the range A1:A18 and name it firstList, select the range B1:B20 and name it secondList.

    2. Next, select the range A1:A18.

    3. On the Home tab, in the Styles group, click Conditional Formatting.

    4.

    Click New Rule.

    5. Select 'Use a formula to determine which cells to format'.

    6.

    Compare function in excel

    Enter the formula =COUNTIF(secondList,A1)=0

    7. Select a formatting style and click OK.

    Result: Miami Dolphins and Tennessee Titans are not in the second list.

    Explanation: =COUNTIF(secondList,A1) counts the number of teams in secondList that are equal to the team in cell A1.

    If COUNTIF(secondList,A1) = 0, the team in cell A1 is not in the second list. As a result, Excel fills the cell with a blue background color. Always write the formula for the upper-left cell in the selected range (A1:A18).

      how to compare two lists in excel for missing values
      how to combine two lists in excel and remove duplicates