Hi Mike,
That number is found in the Redfin data…it is the “Houses Sold” number in the first Redfin data table. I typically use the most current month to date number, but you can set the date range to go back several years to see the residential sales trends…sometimes you’ll see seasonal trends repeated year over year which could help inform…[Read more]

Hi Kevin, thanks. I’m with you on formatting the names… and I have spent a lot of time doing this myself. So, I suppose that somewhat answers my question. However, I’ve not yet put out what I would consider a LARGE mailer like Steve uses here (17,000+). BUT, while the flash fill function is nice for formatting names… we’re still talking…[Read more]

Collins – Here is what you need to do: save these two columns – Owner First Name & Owner Name (First Name First). Delete the other columns having to do with names. Now you can easily see that the owner is Stephen J. Anthony. Sometimes the First Name column is blank and there is a tedious job that you must do at the end of your list scrubbing. You…[Read more]