# Excel Super Links #70 – shared by David Hager

 

SUMPRODUCT Vs. Power Query on Mt. KauKau

http://chandoo.org/wp/2017/06/15/sumproduct-vs-power-query/

Using Excel VBA to control other Office applications

https://exceloffthegrid.com/using-vba-to-control-other-office-applications/

Set the AutoFilter of Excel (tables) to exclude items using VBA code

http://www.excelgaard.dk/Lib/FilterExclude/

Automatically Adjust Secondary Y Axis Scale Through VBA

http://www.myengineeringworld.net/2015/04/adjust-secondary-y-axis-scale-chart-vba.html

Calculating the Nth Best Performance (unique individuals) with Excel and PowerPivot

https://dhexcel1.wordpress.com/2014/07/07/calculating-the-nth-best-performance-unique-individuals-with-excel-and-powerpivot-2/

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