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/download/fltez…8/11_05_13.xlsm
We will be implementing some important changes during 25th and 26th May 2024 which may result in an outage period of the website. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.
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/download/fltez…8/11_05_13.xlsm
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/download/yv2k6…/11_03_13a.xlsx
Re: Separate Pivot Table Filters
Easy.
Ignore other stuff and macro in this example:
http://42aa60af62977a54a0b2-9cbabc6e31c2f105b7fc45ab55236df9.r17.cf1.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/download/1aot6…d/11_02_13.xlsx
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/download/6314h…6/10_31_13.xlsx
Re: SUM until result is lower than
Excel 2010, Tables
Running sum to limit.
http://www.mediafire.com/download/ftacm…a/10_26_13.xlsx
Re: Pull information from lists of similar names.
This Add-In from AbleBits found them all.
http://www.mediafire.com/download/n1bz3…0x/10_23_13.pdf
Re: Line or XY Scatter for showing values over time?
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-9cbabc6e31c2f105b7fc45ab55236df9.r17.cf1.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/download/h1w7a…/10_21_13a.xlsx
Re: Maintaining a Controlled Average
Excel 2010, Tables, PowerPivot
Running monthly average.
For advanced users.
http://58918aa17d4002474361-7ac2b7ee2bc9d74042ff2920135ae995.r25.cf1.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/download/iinwr…1/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/download/bz27i…1/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/download/os3tp…z/10_18_12.xlsm