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
Need to find duplicate values in excel?
Need to find duplicate names in excel
Leads come into my excel spreadsheet. There is a column for first names, a column for last names.
Need the cells to highlight when ONLY BOTH match
For example, using the cell highlight rule for duplicate values, if the names are:
Bob Jones
Mary Jones
Bob Smith
Then Both "Jones" will be highlighted and both "Bob" will be highlighted, which I DO NOT want
I want it to only highlight if Bob Jones is there TWICE
Is this possible?
1 Answer
- garbo7441Lv 72 years ago
You can use a simple formula in conjunction with Conditional Formatting. This example assumes your data is in A1:A100.
Highlight all rows in column A that contain data.
Access Conditional Formatting in the Home tab.
"Use a formula"
Enter this formula:
=SUMPRODUCT(($A$1:$A$100=A1)* ($B$1:$B$100=B1))>1
Format the Fill color you wish to use, and click 'OK' twice.
Adjust column references in the formula as required.
Note: This will conditionally format only column A, which will still identify the duplicate entries.
