I have an excel list of 7,549 owners of real estate property. I will need to delete all of the properties that have a value over $500,000, and all of the properties that have a value under $100,000. Then I will need to delete all of the owners who have more than 2 properties. Then I will need a keyword search on the property owners names and remove all of the names with specific key words such as: "Bank, LLC, LL, LTD, services, equities, realty, real estate, inc, Corp, CO, Properties, associates, asset, assets, LP, assoc, assocs, Property, HUD, Trust, developers, builder, builders. Then I will need to separate the owners who have the same mailing address and property address, with the owners who have a different mailing address and property address, and place them into 2 separate excel files.
Shouldn't take longer than 25 minutes.
I have much more work in the future.