summarise data

hey guys i would like to create a summary of the table into the table below in which when data is entered in the general table the summary table will only show the which have defects such as the poles that are rotten will show up in the table below , also the the pole number from the above...

Hi I have reached the edge of my knowledge and need some assistance. I have a sheet that tracks crops and input chemicals, I need to summaries this into a table so that I can budget the cost based on the month the item is consumed. In Sheet 1. Data The first few columns are for the row...

I am seeking help how to split bookings by date and summarising it by month and year. Thus an example of the data is: Start End Jan-2024 Feb-2024 Mar-2024 Apr-2024 May-2024 Jun-2024 Jul-2024 Aug-2024 Sep-2024 Oct-2024 Nov-2024 Dec-2024 Jan-2025 Feb-2025 Mar-2025 Apr-2025 15/01/2024...

I've been looking around forums and videos for this solution and I'm sure there's something super obvious I'm missing but I just can't figure out how to do this. I have a document with 35 different worksheets. Each worksheet has the same table in the same position and there is a cell that...

Good Afternoon I need help to work out how to show the proportion of days taken per category. I have posted how this looks in Excel however I am struggling to create a Measure in Power BI to replicate it. My data is in one large table, called Sheet 1! The example below: first 2 columns are...

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

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

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

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

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

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

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

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

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:

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

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

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

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