The Formulas, Functions and Visual Basic procedures on this provides examples of Formulas, Functions and Visual Basic proceduresįor illustration only, without warranty either expressed or implied, includingīut not limited to the implied warranties of merchantability and/or fitness forĪ particular purpose. How to sort a table by a field that is not being shown How to search for a city when Excel can't automatically figure out the city The video for today shows extra features: Once you have the first row of data, double-click the fill handle to copy the formula down to all rows.Īll of this data is returned from the data type

The image below shows several columns returning Latitude, Longitude, Population, and Leaders. In this image, the items starting with L are Latitude, Longitude and Leader(s). Start to type a property and the tooltip narrows. A tool tip appears with all of the information known about Little Rock. With Little Rock in A2, go to cell B2 and type =A2 followed by a period. The useful feature is the new formula nomenclature. Note that the state information is removed - leaving only the official name of the city.Ĭlick on any map icon (or select the cell and press Ctrl + Shift + F5) to display a card with information about the city. The cell is successful if you see this map icon. The data is sent to a geography server to figure out the location of each city. In the figure below, the cities were suggested in response to this Tweet - you will notice that the format is varied, sometimes including a state or a state abbreviation or no state at all. To start, type some cities or states or countries in Excel. These new rich data types are an advancement beyond those. In the past, the only real data typing in Excel was when you formatted a cell as Date or Text.

Map chart excel 2016 cities