Welcome to Chandoo.org Forums. Short message for you

Hi Guest,

Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide.
When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing
Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

Yours,
Chandoo

Hi All

Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

Post Spam and you Will Be Deleted as a User

Hui...

When starting a new post, to receive a quicker and more targeted answer,
Please include a sample file in the initial post.

Using Excel to find Lat and Long from a street address (geocode)

After reading Chandoo's posting on "Finding a Zip Code" with the new formulas in Excel 2013, that got me thinking. I have a list of several hundred addresses that I would like to find the lat and long for each one. Can this be done?

If you haven't performed yet the search herein, try going to the topmost right zone of this page (Custom Search), type the keywords used in Tags field when creating the topic or other proper words and press Search button. You'd retrieve many links from this website, like the following one(s) -if any posted below-, maybe you find useful information and even the solution. If not please advise so as people who read it could get back to you as soon as possible.

Now, I need your help with the following questions?
1- Does this qualify as XML for the FILTERXML to work?
2- If yes, please let me know the formula /xpath to filter
AUM Month, Average AUM Excluding Fund of Funds and Average AUM Fund of Fund.
3- If this is not possible by filterxml, do you have any other solution?
Thanks