#Excel Super Links #99 – shared by David Hager

 

Calculate the Sum of Varying Ranges Based on a Condition and Across Multiple Sheets

http://www.xl-central.com/blog.html#complex-sum

Specify a dis-contiguous range for an Excel function argument

http://www.tushar-mehta.com/excel/tips/multi_area_argument.html

Transparent UserForm Background with VBA

http://wellsr.com/vba/2017/excel/transparent-userform-background-with-vba/

Handling Different Granularities In DAX

http://www.daxpatterns.com/handling-different-granularities/

Excel Short & Sweet Tip #7(Highlighting External Links) by David Hager

https://dhexcel1.wordpress.com/2017/04/28/excel-short-sweet-tip-7highlighting-external-links-by-david-hager/

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