“Do Data Types Matter in Power Query? - The Excelguru Blog” - Ilgar Zarbaliyev 🇦🇿's Nuzzel Newsletter for Wed, Mar 17

One of the things that I find a bit misunderstood in Power Query is whether or not Data Types matter. I mean, I'm sure everyone agrees to some point that they do, but you do know just how much they matter, and why? Over the weekend, I received an…

The conclusion of this article is very short: do not use USERELATIONSHIP inside a calculated column to try to change the active relationship. If you need to retrieve a column from another table, use LOOKUPVALUE instead and do not rely on…

Written by Ron de Bruin, Microsoft Excel MVP. A lot of Excel procedures are packaged in Add-Ins. An Add-In is basically a workbook containing some code, that has some other unique properties. An add-in usually has some user interface elements, such…

Index_Search_TTFE_Volume1.xlsm (a list of all workbooks with their searchable keywords, and hyperlinks to those workbooks) TTFE_0001_Conditional Formatting for repeated items in a list.xlsm TTFE_0002_Looking up a value by its intersecting row and…