Posts by Herbds7

Herbds7 · Jan 29th 2011

Re: Summing only some rows of a matrix based on condition

=SUMPRODUCT(data*(tags="a"))

Herbds7 · Jan 28th 2011

Re: Compute Project Start/End Date

Excel 2010 Table
Calculate finish date/time with given
hours per task, within workday/workweek/holiday schedule.
http://c3017412.cdn.cloudfiles…cecloud.com/01_28_11.xlsx
If you get *.zip, don't unzip, just rename *.xlsx

Herbds7 · Jan 28th 2011

Re: Lookup value in multiple worksheets, return values in Row1, 2, & 3 in corresp. co

Excel 2010 sine qua non.

Herbds7 · Jan 28th 2011

Re: Lookup value in multiple worksheets, return values in Row1, 2, & 3 in corresp. co

Excel 2010 PivotTable
Consolidate tabs with Wizard.
No formulas, no code needed.
http://c3017412.cdn.cloudfiles…ecloud.com/01_27_11a.xlsm
If you get *.zip, don't unzip, just rename *.xlsm
http://www.mediafire.com/file/9evxxqkpeatt4pk/01_27_11a.pdf

Herbds7 · Jan 16th 2011

Re: Apply filtering to multiple columns in a Pivot Table

Herbds7 · Jan 15th 2011

Re: Apply filtering to multiple columns in a Pivot Table

Herbds7 · Dec 21st 2010

Re: Compare Columns from several worksheets - Copy Matching Rows To New Sheet

Excel 2010, Tables, PivotTable
Consolidate with PT and macro.
http://c0718892.cdn.cloudfiles…cecloud.com/12_20_10.xlsm

Herbds7 · Dec 8th 2010

Re: Pivot Table Creation Macro

Herbds7 · Dec 6th 2010

Re: Simultaneous vlookups from multiple data lookup ranges

Excel 2010 (only)
Using Tables, PivotTable and Slicer
Bloomberg Professional
http://c0718892.cdn.cloudfiles…cecloud.com/12_05_10.xlsm

Herbds7 · Dec 4th 2010

Re: Updating Graphs with Dynamic Named Ranges Efficiently (Many Series)

Herbds7 · Oct 30th 2010

Re: Pivot Table - Divide one column by another

Herbds7 · Oct 29th 2010

Re: VBA script to collect data from multiple worksheets

Excel 2010 PivotTable
No formulas, no code, no $$

Summing only some rows of a matrix based on condition