Author: Wayne Winston

Excel’s New Geographic Data Types

Office 365’s new geographic data types allow you to type a location in Excel and write formulas that extract information about the location to a different cell. For example, if you enter “Paris” in cell E4, entering the formula “E4.Population” in a different cell will...


Dynamic Ranges and the OFFSET FUNCTION

In our January and February 2019 newsletters we discussed the OFFSET function. Recall that the syntax of the OFFSET function is OFFSET(cell  reference, rows moved, columns moved,height,width). As we explained in our last two articles, we begin in the cell reference and based on the rows...