Re: Identify during which week within a date range the most course meetings occur
I suspect you don't have PowerPivot, a new feature for 2010/2013.
See this book:
"Microsoft Excel 2013, Building Data Models with PowerPivot"
by Alberto Ferrari and Marco Russo
or other "PowerPivot" books.
Without the PowerPivot Add-In, you can still derive your desired data from sheet "Calendar"
Re: Identify during which week within a date range the most course meetings occur
Excel 2010 with free PowerPivot Add-In
Most meetings during semester.
http://www.mediafire.com/view/ftgkv0x1na2v5z4/01_30_14a.xlsx
http://www.mediafire.com/view/ja7wqwgbyi7t3ev/01_30_14a.pdf
Re: Syncronizing two report filter in Pivot chart
Excel 2010 PivotTable, PivotChart, Slicers
http://www.mediafire.com/view/mk5bmsxxnxs2kvd/01_30_14.xlsm
Re: Pivot Table - Counting No. of CDs/Albums
Depends on your style.
Rob Collie's reads more like an illustrated novel.
Ferrari's is more formal.
Re: Convert Summary Table to Pivot Form
Excel 2010 with free PowerPivot Add-In
For reference see this book:
"PowerPivot for Excel 2010" by Russo & Ferrari
http://www.mediafire.com/view/zskt7rk9s84hgi1/01_28_14a.xlsx
http://www.mediafire.com/view/g9v1lkf76hks1og/01_28_14a.pdf
Re: Compare combinations of values/transactions
Don't know since I did not write the code,
but I expect it to fail if you set the sum below the smallest input.
Re: Pivot Table - Counting No. of CDs/Albums
You have to learn PowerPivot.
Get the book "PowerPivot for Excel 2010" or
"Microsoft Excel 2013, Building Data Models with PowerPivot"
by Alberto Ferrari and Marco Russo.
Should take about 3 months, a year at the most.
Re: Compare combinations of values/transactions
Excel 2010 Tables
A typical knapsack problem.
http://en.wikipedia.org/wiki/Knapsack_problem
Macro by Harlan Grove.
http://www.mediafire.com/view/chw87xupcbbb4bo/01_27_14.xlsm
Re: Respective average and summation of consecutive values that r above a threshold v
The work was intended for an advanced user.
I suggest you just paste new data into the LapT column and observe the results.
Any other changes to my spreadsheet will likely break it.
Blindly copying parts of it to your spreadsheet will assuredly not succeed.
Defined Names carry the formulas.
No PivotTables used.
Play with it. You can always reload the file.
Re: Respective average and summation of consecutive values that r above a threshold v
Excel 2010 Tables
Average consecutive values.
http://6b33261c9450e8e39ff7-9a…ackcdn.com/01_26_14a.xlsx
If you get *.zip, don't unzip, just rename *.xlsx
Re: Pivot Table - Counting No. of CDs/Albums
Excel 2010 with free PowerPivot Add-In
http://www.mediafire.com/view/z192nepau3pfrul/01_26_14.xlsx
http://www.mediafire.com/view/k5p9yh7nd1qwhnd/01_26_14.pdf
Re: VBA to filter multiple pivot tables with value in one cell
Excel 2007/2010 PivotTable
Filter multiple row/col/page fields of multiple PTs with drop-downs.
Comparison of Slicers vs Macro method.
http://www.mediafire.com/view/05jpft89s9ndjr2/10_20_11.xlsm
Re: Pivot Table by VBA - Show Month Totals
Excel 2010 with free PowerPivot Add-In
Calculate entries per month and day.
Account for weekends and holidays.
With PivotChart.
http://www.mediafire.com/view/mpttqn8m8qmpbba/01_14_14a.xlsx
http://www.mediafire.com/view/6fkdbm459rqvn05/01_14_14.pdf
Note: Can be done with regular PTs, but that's no fun.
Re: Report filter Pivot Table not behaving how expected.
Your macro will not work
if you have "Select Multiple Items" selected.
Other situations are possible, but then I am not privy to your spreadsheet.
Re: Report filter Pivot Table not behaving how expected.
Quote...just not the result I want...
Unable to guess what behavior you are expecting
or what data you are operating on.
Upload.
Re: Dynamic Averageifs between multiple spreadsheets
Excel 2010, Tables, PivotTable, PivotChart
No formulas, no code needed.
http://www.mediafire.com/view/wdy9ldp44qzopj4/01_14_14.xlsx
Re: Advanced Filter Macro not Working
Excel 2010, Tables
Advanced Filter with macro.
With start and end criteria.
Also shown: Recommended alternate: PivotTable
No formulas, no macro needed.
http://www.mediafire.com/view/5rkixnnbtchuuig/01_11_14.xlsm
Re: Macro to use vlookup or match/offset to fill out a table
Excel 2010 with free PowerPivot Add-In
No macro, no formulas.
Upload file with real data.
http://www.mediafire.com/view/wbdegvfz3ccf4xh/01_06_14a.xlsx
Re: Using the sumifs function for multiple conditions across three sheets
Excel 2010 with free PowerPivot Add-In
No VLookUp(), no helper columns, no macro.
http://www.mediafire.com/view/ks5krjupb6gu9lp/01_05_14.xlsx
Re: Need number of consecutive hours with temperatures below zero
Excel 2010 Table, PivotTable
Start, End, Duration, Top 10
http://www.mediafire.com/view/vb1gc5bd6yvnt1r/01_04_14a.xlsx
http://www.mediafire.com/view/c3g33tba3uchtiq/01_04_14a.pdf
