#Excel Super Links #144 – shared by David Hager

 

Excel Magic Trick 1460: List All Relative Positions in a Single Cell using TEXTJOIN Array Formula

https://www.youtube.com/watch?v=vQRYvNZ6ghM&feature=em-subs_digest

Creating Color Grids for Power BI Scatterplots with the Help of Excel

https://www.makeitpbi.com/single-post/2017/09/02/Creating-Color-Grids-for-Power-BI-Scatterplots-with-the-Help-of-Excel

Applications Settings v2

http://dailydoseofexcel.com/archives/2017/09/01/applications-settings-v2/

Use calculated tables to show only used rows in dimensions

https://www.kasperonbi.com/use-calculated-tables-to-filter-down-dimensions/

#Excel Impossibly Easy #2: Change Sheet Tab Color with a User-Defined Worksheet Formula

https://dhexcel1.wordpress.com/2017/09/01/excel-impossibly-easy-2-change-sheet-tab-color-with-a-user-defined-worksheet-formula/

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s