Posts by Herbds7

Re: Automate calculations based lookups of multiple criteria

Excel 2010 Tables
With patient ID.
http://c3017412.r12.cf0.rackcdn.com/03_15_11.xlsm

Re: Automate calculations based lookups of multiple criteria

My file does not contain a single PivotTable, but uses dynamic Tables.
The Tables update automatically with new "machine-output data"
and no additional Tables are needed.
Please review my file again.
Your sheet "CalcSheet" contains headers, but no sample data,
so your requirements remain undefined.

Re: GetPivotData for first column?

Excel 2010 PivotTable, Tables
Get data from the PT with GetPivotData() from the data field
and with Index() from the row/column fields.
Row/column fields assigned dynamic Defined Names.
Optional macro to change Table size in sync with PT.
Advanced level.
http://c3017412.r12.cf0.rackcdn.com/02_22_11.xlsm
If you get *.zip, don't unzip, just rename *.xlsm

Re: VBA, Conditional Statements with Multiple Criteria, or Pivot Table? Getting start

Excel 2010 (Sine qua non)
With Tables, Structured References, SumIFs(), AverageIfs(), IfError()
No macro (yet).
Advanced level.
http://c3017412.r12.cf0.rackcdn.com/03_15_11.xlsm
If you get *.zip, don't unzip, just rename *.xlsm

Re: Color specific columns i chart based on cell color

All your automation requests can be easily implemented with VBA.
But you have to learn code.
Good book: Excel 2007 VBA, Programmer's Reference.

Re: Extracting all rows between certain criteria

Added notes:
http://c3017412.r12.cf0.rackcdn.com/03_15_11.xlsx

Re: Conditional Formatting Line Charts

Excel 2010, Line Chart
Vary color along a line
according to set points.
With macro. For current, advanced users.
http://c718892.r92.cf0.rackcdn.com/12_18_10.xlsm
If you get *.zip, don't unzip, just rename *.xlsm
http://www.mediafire.com/file/pkmjsvtp2q6n83f/12_18_10a.pdf

Re: Color specific columns i chart based on cell color

Excel 2010 Tables, Pie Chart
Conditionally color slices and table.
With macro.
For advanced, up-to-date users.
http://c3017412.r12.cf0.rackcdn.com/03_14_11.xlsm
If you get *.zip, don't unzip, just rename *.xlsm
http://www.mediafire.com/file/gz2loyh522yultm/03_14_11.pdf

Re: VBA Macro to return non-blank values from multiple columns/rows into 3 columns

Excel 2010 Tables
With virtual reverse PivotTable.
With macro.
http://c3017412.r12.cf0.rackcdn.com/03_13_11a.xlsm
If you get *.zip, don't unzip, just rename *.xlsm

Re: Create a custom Graph from the sample data

Excel 2010 (only) PivotTable, PivotChart
With data labels and Slicer.
With macro.
http://c3017412.r12.cf0.rackcdn.com/03_13_11.xlsm
If you get *.zip, don't unzip, just rename *.xlsm

Re: Determine count based on time interval of X minutes

Excel 2010, Tables, Chart, Gantt
Count # of employees present every minute during one day.
Start, stop and duration of shifts vary randomly.
With macro.
http://c3017412.r12.cf0.rackcdn.com/03_11_11a.xlsm
If you get *.zip, don't unzip, just rename *.xlsm
http://c3017412.r12.cf0.rackcdn.com/03_11_11a.xlsm

Re: Creating Graph using VBA

Excel 2007/2010 PivotTable, PivotChart
Added one of 1000s of other possible arrangements.
http://c3017412.r12.cf0.rackcdn.com/03_10_11a.xlsx

Re: Creating Graph using VBA

Excel 2007/2010 PivotTable, PivotChart
No formulas, no code needed.
Just refresh.
http://c3017412.r12.cf0.rackcdn.com/03_10_11a.xlsx
If you get *.zip, don't unzip, just rename *.xlsx

Re: Pivot Fields to be selected from a diffrent sheet

Easily done in Excel 2010.
http://www.mediafire.com/file/6n4xyfd002f131c/03_10_11.pdf

Re: Countifs with nested year look up

Excel 2010 PivotTable
No formulas, no code needed.
http://c3017412.r12.cf0.rackcdn.com/03_09_11.xlsx
If you get *.zip, don't unzip, just rename *.xlsx

Re: Extracting all rows between certain criteria

Check how 'rown' is defined in Name Manager in my template.
It refers to Table1. You did not create Table1.
For my scheme to work, everything has to be in Tables.
Of course there are myriad of other ways to achieve the same results.
Be inventive and try your own schemes after you have thoroughly understood my scheme.

Re: Extracting all rows between certain criteria

Can't troubleshoot your file since it refers to unknown external files.
For learning purposes, I suggest you start with my file as a template.
Insert your unlinked data into my template in baby steps.
Maintain the Table format since Tables are dynamic and can be moved freely.
Run and save frequently.
Macro available.

Re: Extracting all rows between certain criteria

Excel 2010 Tables
Advanced Filter
Incorporated definition of "Batch"
http://c3017412.r12.cf0.rackcdn.com/03_07_11a.xlsx

Re: Extracting all rows between certain criteria

Excel 2010 Tables
Advanced Filter.
http://c3017412.r12.cf0.rackcdn.com/03_07_11a.xlsx
If you get *.zip, don't unzip, just rename *.xlsx

Re: Align 2 columns and maintain association with 2 adjacent columns

Excel 2010 Tables
Two methods:
With helper column and sort.
With Advanced Filter.
http://c3017412.r12.cf0.rackcdn.com/03_07_11.xlsx
If you get *.zip, don't unzip, just rename *.xlsx