I have a handful of macros I use to scrub the data.
1) Remove duplicates. I remove duplicates by name and also by mailing address.
2) Calc offers. Based on the county I’m looking at, I try to frame my offers by size and sometimes by town (depending on the county).
So when I do my research, I come up with a grid:
These are the low end retail…[Read more]