Re: Change sum range depending on today's date
Excel 2010, Table, PivotTable, PivotChart
With simple IF() formula.
http://www.mediafire.com/view/2aqj28fiq18azyu/11_22_13.xlsx
Posts by Herbds7
-
-
Re: Excel Pivot - subtotal on inner columns
Excel 2010, Table, PivotTable
With source data helper column.
http://www.mediafire.com/view/vf3buackkzo7doa/11_21_13b.xlsx -
Re: pivot chart with offset formula
Excel 2010 Tables, PowerPivot, PivotChart
Consolidate Tables.
http://www.mediafire.com/downl…m80ufw39f8l/11_20_13.xlsx -
Re: Pivot Table with multiple columns
Excel 2010 with free PowerPivot Add-In
Using DAX, not VBA macros.
With Fiscal Year/Month/Quarters.
May it serve the community.
http://www.mediafire.com/downl…2pjd9bji38l/11_18_13.xlsx -
Re: Inventory FIFO Costing
10 Mega Bytes zipped to 683 Bytes!?
Incredible. -
-
-
Re: Add Horizontal Line to Chart Without Creating New Series
Excel 2010, Table, PivotTable, PivotChart
With superimposed charts.
http://42aa60af62977a54a0b2-9c…ackcdn.com/10_03_11a.xlsm
If you get *.zip, don't unzip, just rename *.xlsm -
Re: Merging Data that follows 2 conditions
Learning VBA is also free and for life.
But then you can research and copy
thousands of applicable macros
on this and other forums. -
Re: Merging Data that follows 2 conditions
Excel 2010 Table, PivotTable
No code, no formulas needed.
Learning PivotTables is free and for life.
Same link. -
Re: Merging Data that follows 2 conditions
No free AbleBits. You'll just save time.
You need to combine only "quantity",
and then do another step as shown in my file. -
Re: Merging Data that follows 2 conditions
Excel 2010, Table, AbleBits Add-In
http://www.mediafire.com/downl…41bnl2ju9b/11_10_13a.xlsx -
Re: Bar Graph with 3 variables
Excel 2010 Table, PivotTable, PivotChart
http://www.mediafire.com/downl…7leqlp8952z/11_10_13.xlsx -
Re: XL Charts: Secondary Y-Axis
Applies to all.
Upload. -
Re: Formatting - VBA
Excel 2010, Table, PivotTable
No code, no formulas needed.
http://www.mediafire.com/downl…5fco8ygkgg/11_08_13a.xlsx -
Re: XL Charts: Secondary Y-Axis
Excel 2010, Table, PivotTable, PivotChart
Insert dummy columns.
Upload your data if stuck.
http://www.mediafire.com/downl…c8d1uo7nj8/10_02_11a.xlsx -
Re: Calculate Resolution date and time based on priority SLA
With macros, not UDFs.
Macros need editing if Table headers change.
http://www.mediafire.com/downl…c1s2fb2prs3/11_06_13.xlsm -
Re: Calculate Resolution date and time based on priority SLA
Added CF to color "Close" date.
To update, copy and paste date/time from another *.xlsx.
There isn't enough space here to explain Fin()
Re-download link. -
Re: Calculate Resolution date and time based on priority SLA
QuoteSorry the answer should be Monday 02/09/2102 14:01.
My calendar does not cover 90 years. Sept 2, 2012 is a Sunday.
All my dates are in US format (mm/dd/yy)
Monday, Sept 3, 2012 is a US holiday (Labor Day). See holiday sheet.
You did not edit Table3 for your priority hours and working hours.
I highlighted all your mistakes.
My work needed no corrections.
Re-download link. -
Re: Calculate Resolution date and time based on priority SLA
Quote...I want the resolution date and time be per...
Edit the tables as desired.Quote....is there an easier way...
There are monster formulas, macros and PowerPivot, none easier to customize or to maintain.