Re: Calculate Resolution date and time based on priority SLA
Excel 2010, Tables, Defined Names, Macro
Priority SLA
Calculate resolution date/time
http://www.mediafire.com/downl…z526pwe5u68/11_05_13.xlsm
Posts by Herbds7
-
-
Re: Determin Hrs per time bracket
QuoteI've scoured Google and this forum ... many answers but none seem to work for me
Which one came closest?
Which part did not work for you? -
Re: Separate Pivot Table Filters
Excel 2010, Tables, PivotTables, PivotCharts, Slicers
Marked changes in instructions in red.
All PTs/Charts sync'd to one reference PT.
http://www.mediafire.com/downl…rii7u7dgpf/11_03_13a.xlsx -
Re: Separate Pivot Table Filters
Easy.
Ignore other stuff and macro in this example:
http://42aa60af62977a54a0b2-9c…rackcdn.com/10_20_11.xlsm
If you get *.zip, don't unzip, just rename *.xlsm -
Re: Separate Pivot Table Filters
A dummy PivotTable with Page Fields only.
Hide the connected Slicers. -
Re: Separate Pivot Table Filters
Excel 2010
Use Slicers.
Attach files, not pictures. -
Re: Finding value using formulas,functions or macros from intersection of 2 data ser
Excel 2010, Curve Fitting
http://www.mediafire.com/downl…6911ub30t1d/11_02_13.xlsx -
Re: Pivot Table: Ignore specific months of specific years when grouped by month and y
Insert dummy months without data into Table1.
Create macro to automate.
Same link. -
Re: Pivot Table: Ignore specific months of specific years when grouped by month and y
Excel 2010, PivotTable, PivotChart
Date Filter > Dates Between
http://www.mediafire.com/downl…hts0757q7z6/10_31_13.xlsx -
Re: SUM until result is lower than
Excel 2010, Tables
Running sum to limit.
http://www.mediafire.com/downl…mr9bpbbptya/10_26_13.xlsx -
Re: Pull information from lists of similar names.
This Add-In from AbleBits found them all.
http://www.mediafire.com/downl…z3ghx06vtq0x/10_23_13.pdf -
-
Re: Multiple lookup values returned into one cell
Excel 2010, Tables
Consolidate, merge values into one cell.
With macro and hidden PivotTable.
No trimming or duplicate removal.
For more help, upload complete file.
http://42aa60af62977a54a0b2-9c…rackcdn.com/04_18_11.xlsm
If you get *.zip, don't unzip, just rename *.xlsm -
Re: Line or XY Scatter for showing values over time?
Excel 2010, Tables, X Y Chart
http://www.mediafire.com/downl…jzd5uov7ip/10_21_13a.xlsx -
Re: Maintaining a Controlled Average
Excel 2010, Tables, PowerPivot
Running monthly average.
For advanced users.
http://58918aa17d4002474361-7a…rackcdn.com/10_20_13.xlsx
If you get *.zip, don't unzip, just rename *.xlsx -
Re: Calculating using times and different rates for bookings
AmLine,
You are right,
6PM to 8PM works, but 7PM to 9PM does not work
in olivetwist's spreadsheet. -
Re: Pivot table filter, greater than 30days old, dynamic
Excel 2010, Table, PivotTable
Three ways:
Helper column
Macro
PowerPivot
http://www.mediafire.com/downl…r942c6773f1/10_14_13.xlsm -
Re: Solving for best-fit variable over range of data
Excel 2010, Tables
Best done with Least Squares.
Don't use Goal Seek or Solver.
http://www.mediafire.com/downl…i5ak7ywxxj1/10_13_13.xlsx -
Re: Apply filter to a pivot table from a selection on another page
Upload your file with multiple PTs and your macro tries.
-
Re: Apply filter to a pivot table from a selection on another page
Don't unzip, but change the suffix from *.zip to *.xlsm
or try this link
http://www.mediafire.com/downl…pkx2fv4gi3z/10_18_12.xlsm