I routinely create large lists of address and then have to map them. I get addresses that are clearly invalid (1 homeless dr, 0 unknown st, etc). These really mess up the mapping program (batchgeo.com). I would like to be able to search my workbook for any cell in the first column that contains a zero, and delete that whole row.
The next step would be to delete any row that contains any word from a specified list (homeless, anywhere, unknown, etc) in the second column. I expect this is much more difficult. I can provide sample sheets if necessary. Any help with either of these would be greatly appreciated. Thank you, Steve -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
