coloradoperkins
New Member
- Joined
- Mar 11, 2022
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
I have two very large data lists with names. One list has the names as LastName, FirstName all in one field. The other list has a field for LastName and a field for FirstName. I tried doing a conditional formatting to highlight duplicates, but this did not show up anything, I assume because the first list includes both first and last names. Is there a way to get it to flag partial duplicates so it will catch the last name? I know this would be imperfect but I thought I could use it to start.
These lists are large, list one is 3500 records and list two is about 30,000. Please help! We started going through the lists manually and spent about two hours to just get through the D's.
These lists are large, list one is 3500 records and list two is about 30,000. Please help! We started going through the lists manually and spent about two hours to just get through the D's.