Hi-lite rows with at least 2 matching columns

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

I've tried lots of searches but keep getting answers for rows that match exactly. I need the opposite. I have a spreadsheet with 3000 rows. Here's an example:

Smith Joe 123 valencia joe@yahoo.com
Gates Sam 335 road gate@gmail.com
Smith Joe 122 valencia joe@yahoo.com
Arbor Ann 13 shirley st aarbor@msn.com
Smith Jo 123 valencia jo@yahoo.com


Is there anyway to highlight rows based on at least 2 matching columns? I'm entering data based on handwritten notecards and sometimes it's difficult to read people's writing. As you see above, all the Joe Smith rows are the same person..but because his handwriting is difficult to read I've interpreted it differently each time.

Once I get all the matching rows highlighted, I'll be able to deduce which are correct and which were entered incorrectly. So far I've been using a conditional formula to show all the matching email's and go from there...but those can be hard to decipher and I may not have written it the same way for each entry.

Thanks for any help.



1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc and post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too