Learn how to work around a couple bugs in Excel to return double values; drill down on lists with anonymous types; and learn the difference between Build and Rebuild.

The Excel ISBLANK function returns TRUE if cell value is blank and False if the cell is not blank, and it is also an information function.

Learn how to combine Microsoft Excel’s ROW() and ROUNDUP() functions to create a flexible serial function that returns groups of consecutive values.