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

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top