1. T

    Help to calculate 12 hour SLA, 7 days a week based over 10 hour opertaing day

    Hello, I would be most grateful for help, I am trying to calculate SLA for call attendance based on 7 days per week with operating hours of 08:00 - 18:00, SLA of 12 hours. The only solution I can find uses workday which then does not return correct weekend calculations, I feel so silly but can...
  2. D

    3 equations all N/A

    I have 3 equations i have tried, i am trying to do an index match with month and year but they are all returning #N/A =INDEX('Operating Modes'!C6:O150,match(month(B7)='Operating Modes'!B54:B150)*(year('semi annual'!C3)='Operating Modes'!A54:A150),MATCH('semi annual'!C4,'Operating...
  3. E

    Index Match

    Hi All, having some formula difficulties and hoping somebody may be able to assist. I am trying to find the corresponding value on the "total operating expenses" line on 'G+A' tab (column names are in column A, the data goes from columns B:AM), provided that the value in row 7 is "Company...
  4. L

    json to excel VBA??

    Hi everyone, May I know if there is a solution to convert my json file to excel format... below data extracts from json... I would like to show 1sr row:add_amount,available_amount,budget_account_code,budget_account_name... 2nd row:0,0,R13006,A123... 3rd row:0,0R13006,A1234...
  5. H

    Duration Curve

    I am trying to create a Duration Curve, ie, a Scatter Graph consisting of hundreds if not thousands of data points plotted against sequential days (operating time). I need to be able to determine the value at 10% of the operating time (which may not be an integer) and draw a horizontal line...
  6. bencar

    Explain Why this Pivot Table is Layed Out this Way

    Hi guys, Trying to figure out why this pivot table is layed out the way it is. Here are my 4 questions. Below that is the exercise and its info. 1. Why is 'design' in the column area? 2. Why are 'amusement park' and 'roller coaster' in the row area? 3. Why is 'type' in the filter section? 4...
  7. S

    Best mobile workstation to run Excel 2016 PowerQuery and Powerpivot?

    Seeking laptop recommendations. I’m currently on an XPS27 AIO which is a 64-bit operating system, Intel(R) Core(TM) i7-4770S CPU @ 3.10 GHz with 16.0 GB installed RAM.

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...