Tag Archives: power bi

2-empty-cells

Dear Analyst # 110: A tutorial on how to fill values down with Excel VBA and Google Apps Script (Vancouver Power BI/Modern Excel re-broadcast)

Have you ever faced a spreadsheet where one column contains values for each “section” of the spreadsheet but you want to fill those values down through the rest of the column? This is a common problem when you get a data dump from a database or perhaps a copy/paste from a PivotTable. You have values […]

Dear Analyst #51: Who is the real audience for custom data types in Excel?

To much fanfare, custom data types in Excel were released late last month (October 2020). This feature started off as a way to see “rich data” relating to stocks and geography in a cell, and now Microsoft is letting you define your own data types. Perhaps you want to see all attributes for a customer […]