Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Trending News

Promoted
?
Lv 4
? asked in Computers & InternetSoftware · 4 years ago

How can I match data in two columns in MS Excel?

1 Answer

Relevance
  • Adam
    Lv 5
    4 years ago

    Find duplicate values in two columns

    1. Highlight column A by clicking the column header.

    2. Select the Conditional Formatting button under the Home tab.

    3. Select New Rule from the Conditional Formatting drop-down list.

    4. Select the 'Use a formula to determine which cells to format' option.

    5. Enter the formula provided in the text box.

Still have questions? Get your answers by asking now.