Monthly Archives: January 2016
Sum up the diagonal of your data anywhere on a Sheet
January 26, 2016
The title of this post is actually a question I got on one of the last trainings I gave in 2015. It struck me as a great little sample of using array formulas, and ...
Donate
Recent Posts
Recent Comments
- on Turning Product Descriptions into a list of attributes with Power Query
- on Scroll trouble in Excel (scrolling beyond your data)
- on Scroll trouble in Excel (scrolling beyond your data)
- on Turning Product Descriptions into a list of attributes with Power Query
- on Excel FILTER Function – The Function that does Everything
Archives
- March 2022
- February 2022
- January 2022
- November 2021
- September 2021
- July 2021
- June 2021
- April 2020
- March 2020
- September 2019
- August 2019
- October 2018
- June 2018
- May 2018
- April 2018
- March 2018
- February 2018
- January 2018
- June 2017
- February 2017
- November 2016
- June 2016
- May 2016
- April 2016
- March 2016
- January 2016
- November 2015
- June 2015
- May 2015
- April 2015
- March 2015
- February 2015
- January 2015
- December 2014
- November 2014
- October 2014
- September 2014
- August 2014
- July 2014
- June 2014
- May 2014
- March 2014
- October 2013
- July 2013
- June 2013
- May 2013
- April 2013
- March 2013
Categories
- 3D Map
- Array Functions
- Calendar
- Cell Format
- Charts
- Conditional Formatting
- Conferences
- CSV
- Data Model
- Data Types in Excel
- Data Validation
- Dynamic Arrays
- Dynamic Ranges
- Excel
- Excel 365
- Excel Conferences
- Excel Facts
- Excel Functions
- Excel Shortcuts
- Excel Tools
- Lists in Power Query
- M
- Pivot Table
- Power BI
- Power BI Designer
- Power BI Desktop
- Power Map
- Power Query
- PowerPivot
- R Academy
- R Language
- Uncategorized
- VBA
- Xcessories
Follow Us
Tags
Amsterdam Excel Summit
Array functions
BI
Calendar table
Cell Format
Charts
CHOOSE function
Conditional Formatting
Custom Cell Format
Data Validation
DATE function
Dates
Dynamic Ranges
Excel
Excel conference
excel facts
Excel Functions
Excel Shortcuts
Excel Unplugged
F5
Fill and Series in Excel
Get Data From Folder
INDIRECT function
Lists
M
Microsoft Excel
MID function
M Language
Month Function
MS Excel
MVP
Office 2016
Pivot Table
Pivot vs PowerPivot
Power BI
Power BI Desktop
PowerPivot
Power Query
R Academy
R Language
ROW function
Shortcut
TODAY function
VBA
Vlookup