Re: Display (filter) rows depending on multiple text conditions in multiple columns
Excel 2010, Tables, PivotTables
There are oodles of other PT arrangements.
http://www.mediafire.com/view/mm5qsahu4nddmae/12_30_13.xlsx
http://www.mediafire.com/view/0xxtojabgn0fjkd/12_30_13.pdf
Re: Keeping field order the same in pivot table
Excel 2010, PivotTable
Sort date/time
http://www.mediafire.com/view/hvfhm2k8tr1jvac/12_24_13.xlsx
Re: Formula to include range of dates on all tabs
Excel 2010 with free PowerPivot Add-In
Calculate values from nn days/months back to today. With DAX formula.
Upload your file if you have difficulty fitting your data to my scheme.
Can also be done with regular PT and macro, but not with formula.
http://www.mediafire.com/view/ufbdy562tr04r3s/11_16_13a.xlsx
Re: Pivot table updating to linked workbooks
Excel 2010 with free PowerPivot Add-In
See this book:
PowerPivot for Excel 2010 by Russo & Ferrari.
Should take only a few months to learn.
None of the original work was salvageable.
http://www.mediafire.com/view/3dt5ff9ctldgo4i/12_20_13.xlsx
1.0 MB
Re: Pivot table updating to linked workbooks
Your attached file does not illustrate your problem.
A text description of your problem is unlikely to reveal
the mistakes you made in your spreadsheets.
An effort to create a compact example that displays your problem
will almost certainly provide an insight into your problem.
MediaFire.com accepts MB size files.
Re: Pivot table updating to linked workbooks
Create minimalist file(s) that still shows the problem
and upload here or at a file sharing site.
Re: Working Hours and Days calculations
Excel 2010, Tables
http://www.mediafire.com/view/xq67gk1kf70hra5/12_19_13a.xlsx
Re: Convert data in table to data in list
There are many clues (comments) sprinkled about for you to deduce the methodology.
If you open the hyperlinks, you can follow the macro as a pseudo instruction set.
Another option is PowerPivot, if you are working off a big DataBase.
Re: Convert data in table to data in list
Excel 2010 Table, PivotTable
De-Normalize Array into PivotTable friendly Table.
http://www.mediafire.com/view/4p0si0k24cq20ka/12_17_13.xlsx
Re: S Curve
Excel 2010, Table
S Curve
http://www.mediafire.com/view/9dc57msp0d9di0a/12_13_13.xlsm
Will not work with Excel 2003 or MultiPlan.
Re: Finding Max Rate of Change with Exceptions
Curve fit with LINEST() and take the derivative.
Attach *.xlsx, not *.jpg
or upload big file to any file sharing site and post link.
Re: Calculation net working hours when business end time is less than business start
QuoteI found this workbook...
Please insert the link to the unspecified workbook.
The formula does not appear in the WS mentioned in this thread.
I suggest you start a new thread.
Read the rules on hijacking.
Re: Text to columns and pivot table possible?
Excel 2010, Tables, PivotTable
Count upgrades.
http://www.mediafire.com/view/2f7ihmgvuxgxd6j/12_03_13.xlsx
Re: changingl contour plot colors using vba
Excel 2010, Tables, PivotTable, PivotChart
3D Surface Plot with colored bands.
With macro.
http://42aa60af62977a54a0b2-9c…rackcdn.com/06_04_11.xlsm
If you get *.zip, don't unzip, just rename *.xlsm
Re: Pivot table daily data but monthly targets
Excel 2010 with free PowerPivot Add-In
Weekly sales and targets compared.
http://www.mediafire.com/view/qjpxca9fci7aoz8/12_01_13.xlsx
Re: Concurrent Calls With Start And End Time- How many?
Excel 2010, Tables, PivotTable, PivotChart
Concurrent calls with dates.
http://www.mediafire.com/view/2qxnym3i63hrtpq/11_23_12b.xlsx
Re: Convert unique address list from vertical to horizontal
Excel 2010, Tables
Transpose blocks from vertical to horizontal.
With variable size data blocks.
With macro and generic data.
Customize macro to fit your specific database.
http://www.mediafire.com/view/evy9dw7le57ic2q/08_23_10.xlsm
Re: Filter Multiple Selections Data Validation
Cross posted at:
http://www.excelguru.ca/forums…elections-Data-Validation
Re: a formula that will return the largest count of product brought by each customer
Excel 2010 with free PowerPivot Add-In
With generic business sales data.
http://www.mediafire.com/view/nq2vwesztzecq9q/11_23_13a.xlsx
http://www.mediafire.com/view/21y52od63316y2w/11_23_13a.pdf
Re: Change sum range depending on today's date
Excel 2010 with free PowerPivot Add-In
For the next generation of users.
Even simpler. No helper column.
Same link.
