summarise data

  1. J

    Automatically sorting event totals by hours

    I'm a relative newbie to the power excel world, so don't know if this is possible or not. I have 1 field that indicates the number of attendees 1 field that indicates start time 1 field that indicates end time. What I would love to automate is to have individual fields for the hours of the...
  2. K

    Summarising row data into a separate column

    Hi, I am trying to take string data from multiple sheets that is listed in the same row each time, and summarise it in a column (or row), while removing any gaps. There may be a quite obvious fix, but I have found no solution. So I have data that looks like this: Sheet 1 <tbody> A B C D E...
  3. S

    Combine multiple sheets with same name from seperate wbs in a folder into one workbook

    Hello All, I want to combine a specific tab ("Summation") in all workbooks in a folder to a single workbook. I have my macro asking for the file path, a file name pattern and the tab name from each workbook. The only 2 I really need are the file path and the tab name but the middle is just...
  4. G

    Summarizing data on another tab

    I have been looking around online and have not been able to find what I need. As you can see below I have a list set up of different capitalization rate percentage ranges. (Note: the "xx" max/min should be actual rates - I set up this table before I had any of the rates) I would like to set up...
  5. J

    Summarising Multiple BOM Tables into one - best solution?

    G'day folks, So I am looking for multiple/best solution(s) to summarise/consolidate multiple tables into one. These tables are Bill of Materials (BOM's), on each worksheet will be a table summarising the materials required for each product assembly. The tables are made up of Part Numbers...
  6. D

    Summarize Data from Other Sheets Into A Single Sheet

    Objective:to pull summary details of selected spreadsheets and place the results on a new worksheet. I have a userform that reads all the various worksheets in the workbook and applies pattern matching on the name, so as to only pull relevant worksheets for a user to select from. The user can...
  7. R

    Looking for advice on the best way to summarise data..

    Just looking for some 'best practice' advice on summarising a huge amount of data... Quite simply, I have a huge worksheet which I use for analysing stocks. Column A shows Stock Names, Column B shows yesterdays prices, Column C shows todays prices, Column D shows % change on yesterday's price...
  8. A

    Best Approach to Summarise Data

    Hi, I have a couple of data sets that I need to create an overview for and I’m struggling how to group, count, sum etc. various data sets. Essentially, I have different data sets for: Revenue Data Sales & Pipeline Data Consultant Engagement Data What I have been racking my brain over is the...
  9. F

    How to extract the same 5 celss from multiple excell work books and display them in rows

    I have a folder with a few hundred Excell workbooks. All the formatting is the same in each workbook. How do I extract 5 cells from each workbook without manually openig them up? I would like to list them 5 colums wide by a few hundreds rows of the data. Thanks for your help. :confused:
  10. I

    Custom summarizing in pivot table?

    Hello, I have a pivot table with Months and Weeks as row headers and Members and Enrollees as column headers. The weeks collapse into the months. I have two problems. 1) I need the month totals to show up all the time instead of only when the weeks are collapsed. 2) For members I need the...
  11. L

    Lookup or Advanced filter to Summarise data?

    Hi - I apologise if there is a result already posted but I need something quite secific and don't have time to adapt & play. I need to lookup a list on Sheet 1: "Training Register" and find all people scheduled for "Session ID" then populate a summary list on Sheet 2: Training Session Summary...
  12. H

    Where a blank cell is found in column B, sum the previous two cells in column B.

    Can someone assist me with this: Where a blank cell is found in column B, sum the previous two cells in column B. Continue until no data remains. I've included a sample: COLUMN A COLUMN B <TABLE style="WIDTH: 252pt; BORDER-COLLAPSE: collapse"...
  13. J

    Summarising several classes of data based on condition of each class

    Hi, I have several sets of data and would like to summarise all the No's in the "Acceptable?" column (in G, L, Q... and so on) and copy the relevant rows including the first two columns (dates and days) not just for Class 1 but 2, 3... and so on, to another sheet. However, where there is no...

Some videos you may like

This Week's Hot Topics