data summary

  1. T

    How to calculate standard deviation

    Hi, I need to calculate standard deviation from the following table. The issue is that I have Number Column and a QTY Column For example No QTY 34 6 55 7 23 0 79 55 88 3 Is there a way I could do it in one formula please?
  2. S

    Data Summary worksheet help!!

    Hello All, I am hoping that this forum will be able to help me out. I have data across multiple worksheets (named as different countries) all with the same format as below: <TBODY> COUNTRY TOTAL</SPAN> Jun-12</SPAN> Jul-12</SPAN> Aug-12</SPAN> Sep-12</SPAN> Oct-12</SPAN> Nov-12</SPAN>...
  3. I

    Large Data Set

    I have 4 columns of data with field names/column headers (people, office, case number, date). I have over 60,000 rows of data within those 4 columns. A single case number can have multiple people work on it over a given period of time in different offices (ex: John worked on case number 3 during...
  4. A

    Data Summary

    Is there anyway to take the data on the image below and condense it into something like the image after that. This is just a sample of the workbook, I would need something that could work across the whole sheet which has the same layout as the image below. Any ideas would be greatly...

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...
Top