summarize data

  1. A

    Summarize data from five different columns and maintain column labeling and format

    Hello, I have set of data of time spent on various activities, tasks, and projects for a set of clients over a period of time. I'm looking to summarize that data to determine how much time was spent each day on each combination of the activity, task, project, and client. I tried a pivot table...
  2. W

    How to get calculate function to display group result on each sub group level Power Query

    Basically I have been trying to get the calculate/filter function to work for me and in most cases it does, but one measure is giving me issues. The calculation I am trying to do is =IFERROR([OVC QTY]/[OVC Plan],0). The results of this function gives me what I need, however the results are...
  3. C

    Summarize data

    I am trying to Consolidate data from about 9 or 10 different workbooks. The data is in the same format (columns), however the amount of data (length of each spreadsheet) is different and in no particular order. I am trying to summarize the data by the name of the employee and the date. I am...
  4. J

    Summarizing Non-Continuous Years Ranges

    I have a large set of part numbers that I need to summarize for the vehicle make and year ranges that they fit. I took the simple approach of finding the min and max year and concatenating make, max year - min year (e.g. Chev 2004-2000). However the year ranges are not always continuous and I...
  5. B

    Summary Page via VBA help

    Greetings, Need help creating a summary page by date. I have 17 sheets in a workbook however, 12 (Sheets 2-13) of them have data that needs to be summarized. Sheet 1 is the summary page. On the Sheets 2-13 "J1".value is the date Range("L10:L45") has numbers that need to be totaled based...

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