Hi Everyone,
I have a list of properties from a lead data base and I have a list of properties which have already been researched. I want to isolate the properties that have not been researched from the lead data base.
I created a simple Unique identifier which used the legal address of the property. I'm able to use the conditional formatting to highlight the duplicates, but when I go to delete them, it only deletes the duplicate, I need to delete the original as well.
1. What is the best route to achieve isolating the NOT YET researched properties?
OR, an idea I have...
2. How do I formulate an IF Formula to say, if the value is highlighted (or isn't unique), return 1, if it is unique, return 0. then I can just go and delete the ones.
the list has several thousand records.
Bookmarks