Hi guys-
I'd appreciate a second set of eyes on a problem. I have a huge data sheet on Farmer's Markets throughout the United States. I have to find out how many farmers markets there are per capita in each state. The catch is that I must exclude all Farmer's Markets in cities with more than 1 word in their name. I used a Len(Trim) equation to give me values for the number of words in the city name so it looks like this:
Screen shot 2015-07-07 at 2.54.06 PM.png
Bookmarks