#Excel Super Links #18 – shared by David Hager

The Excel Rollover Mini FAQ

https://optionexplicitvba.com/2012/09/17/the-excel-rollover-mini-faq/

Collating with Excel Formulas from Multiple Sheets based on Conditions

https://excelxor.com/2014/10/16/collating-from-multiple-sheets-based-on-conditions/

Use any Map with Power BI

https://www.kasperonbi.com/use-any-map-with-power-bi/

The Magic of IF(VALUES()) in Power Pivot

https://powerpivotpro.com/2011/03/the-magic-of-ifvalues/

#Excel Shift Calendar by David Hager

https://dhexcel1.wordpress.com/2017/04/03/excel-shift-calendar-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