Re: How to display a conditional point on a chart
Excel 2010 Tables, Chart, Points
Select point from drop-down list and
show its marker and data label on chart.
Draw ruler lines to axes.
With macro.
Easy. Not.
http://c3017412.r12.cf0.rackcdn.com/06_08_11.xlsm
If you get *.zip, don't unzip, just rename *.xlsm
Re: Filtering Pivot Table In VBA
Here is a Pdf file with the text macro.
Two pages.
Can be adapted to other version of Excel,
if desperate.
http://www.mediafire.com/file/j0m414i4ubxe56s/05_28_11.pdf
Re: Filtering Pivot Table In VBA
Excel 2010 PivotTable
Filter PivotItems
Applied to dates and currency.
http://c3017412.r12.cf0.rackcdn.com/05_28_11.xlsm
If you get *.zip, don't unzip, just rename *.xlsm
Re: count unique occurrences with criteria referring two tables
Excel 2010, Tables
Advanced Filter
With drop-down criteria lists.
Show all results and count them.
With macro.
http://c3017412.r12.cf0.rackcdn.com/05_23_11.xlsm
If you get *.zip, don't unzip, just rename *.xlsm
Re: Count of concurrent calls from multiple start/end times split over intervals
Excel 2010 Tables, Chart
Concurrent with Countifs.
http://c3017412.r12.cf0.rackcdn.com/05_22_11.xlsx
If you get *.zip, don't unzip, just rename *.xlsx
Re: Returning a product with the 2nd largest value of a certain customer
Excel 2010
With PivotTable, no formula,
or with monster formula.
http://c3017412.r12.cf0.rackcdn.com/05_20_11.xlsx
If you get *.zip, don't unzip, just rename *.xlsx
Re: Combining two data sources in one stacked bar graph?
The trick is to upgrade to Excel 2010
Re: Combining two data sources in one stacked bar graph?
It's a standard Bar Chart, not stacked.
Re: Combining two data sources in one stacked bar graph?
Excel 2010 Bar Chart
Like this?
http://www.mediafire.com/file/2fp1vykwjhn8ist/05_19_11.pdf
Re: conditional colours within a pie chart based on a grading system
Excel 2010 Tables, Chart
Conditionally color pie chart.
With macro.
Without mercy.
http://c3017412.r12.cf0.rackcdn.com/05_19_11.xlsm
If you get *.zip, don't unzip, just rename *.xlsm
Re: Create matrix of correlated value based on combinations
Excel 2010 Tables
Matrix of frequency of combinations.
With MMult()
No code.
http://c3017412.r12.cf0.rackcdn.com/05_18_11.xlsx
If you get *.zip, don't unzip, just rename *.xlsx
http://www.mediafire.com/file/k3w77lrhic6736h/05_18_11.pdf
Re: Excel\Conditional SUMPRODUCT
Excel 2010 Advanced Filter.
Conditional Weighted Average.
Short formulas.
No Sumproduct or Sumifs.
http://c3017412.r12.cf0.rackcdn.com/05_17_11a.xlsx
If you get *.zip, don't unzip, just rename *.xlsx
Re: Taking 3 Seperate Values Leaderboard
Excel 2010 PivotTable
Consolidate and rank Tables
http://www.mediafire.com/file/vuunny70vu36a2v/05_17_11.xlsx
http://www.mediafire.com/file/2a2xwqtpg6jzpm5/05_17_11.pdf
Re: Pivot Table Help
Excel 2010 PivotTable
Count uniques
http://c3017412.r12.cf0.rackcdn.com/05_07_11.xlsx
If you get *.zip, don't unzip, just rename *.xlsx
Re: How do I add detail data counts to summary data worksheet?
Excel 2010 Tables, PivotTable
Consolidate tabs into one Table with macro.
Pivot as desired.
http://c3017412.r12.cf0.rackcdn.com/05_04_11.xlsm
If you get *.zip, don't unzip, just rename *.xlsm
Re: Copy rows to other sheet based on multiple conditions in multiple columns
Excel 2010 Tables
Filter on multiple columns.
Create new Table.
With macro.
http://c3017412.r12.cf0.rackcdn.com/05_03_11.xlsm
If you get *.zip, don't unzip, just rename *.xlsm
Re: Filter Sheets using Criteria from Drop Down Box
Excel 2010 Tables, Filter
Added another drop-down list filter for bar code.
Free uploads at MediaFire.com
http://c3017412.r12.cf0.rackcdn.com/05_02_11.xlsm
If you get *.zip, don't unzip, just rename *.xlsm
Re: Filter Sheets using Criteria from Drop Down Box
Excel 2010 Table, Filter
With drop-down list and macro.
http://c3017412.r12.cf0.rackcdn.com/05_02_11.xlsm
If you get *.zip, don't unzip, just rename *.xlsm
Re: creating parallel arches
Excel 2010 Shapes
Quarter Circles
http://www.mediafire.com/file/78urk3m7enyoncg/05_01_11.xlsm
Re: Compare 2 columns of different workbooks and display match on another worksheet
Excel 2010 Tables, PivotTables
Compare Workbook Tables.
No formulas, no code needed.
http://c3017412.r12.cf0.rackcdn.com/04_26_11a.xlsx
http://c3017412.r12.cf0.rackcdn.com/04_26_11b.xlsx
If you get *.zip, don't unzip, just rename *.xlsx
