aggregate

Good morning everybody I have a large table which I need to reorganise. It has two key fields and one of data, thus: <tbody> Contract Line Charge ID 10914 1 10010016 10914 1 10010932 10914 2 10020624 10915 1 10000883 10915 2 10010703 10915 2 10010244 10915 2 10010243 </tbody>...

I get a feeling this might not be possible, but I have a table that uses the Aggregate function to average a column. It needs to be Aggregate, because that allows me to use slicers to see averages for different items in my table. The problem is, the Aggregate average is averaging the zeros and...

I'm making a grocery list in Excel. One sheet has my list then next sheet has a listing of my local grocery stores with items, prices and weight. I want to search thru the items against what's in my grocery list for the lowest price. I only have Microsoft Excel 2010. I'm trying to use MIN and...

Hi I'm making a dashboard where I import raw data reports from an old fashioned ERP system into different sheets. The dashboard sheet then retrieves and calculates different results and combines these into 1 view on 1 sheet.To find the top performing customers YTD, the dashboard retrieves it's...

<colgroup><col><col><col><col></colgroup><tbody> Store Average Daily Sales Inventory Days On Hand (Inv/Sales) New York, NY 20 40 2 Seattle, WA 25 200 8 Detroit, MI 75 225 3 Dallas, TX 5 50 10 Total 125 515 4.12 </tbody> How to calculate what each stores weight is in the aggregate...

Hello, I am trying to aggregate weekly quantities into monthly ones. THIS LINK shows the dataset in question, the formula I created to aggregate these subsets, and the organization tactic I used. Is there any way I can make this formula dynamic? I feel like there is an easier way to do this...

I have an office inventory spreadsheet and the following is what I would like to do: Get a running total for quantity even if I sort any column the running total should not break Get Running total sorted by item and should reset when the item name changes Get running total (for visible rows...

I have a list of employees in a spreadsheet where I record if they paid their dues or not. I am looking for a formula solution to generate a list of employees that have paid. I understand this can easily be achieved by filtering, but in this particular case, I want to use a formula. <tbody>...

From a previous post I have been using the function at the bottom of the post. I now wish to use the aggregate function again to find the Max value from a different range of cells but still based on only those records that are in a particular year. I have tried modifying the function as below to...

Hi Has anyone noticed if AGGREGATE() processes data faster than SUBTOTAL() if you have a lot of data you are calculating? Thanks. Patriciaanne

Hi, I have some table data where I would like to generate an aggregate reciprocal position. This relates to modelling allocation of costs within an organisation. E.g. 5 departments a, b, c, d, e receive costs of -1, -2, -3, -4, -5 respectively. I would like to generate in the cleanest and...

Here's my code: aggregate = "'" & ThisWorkbook.Path & "\" & counter & "\[aggregator.xlsm]" & ws.Name & "'!percent" prior = "[" & counter & ".xlsm]" & ws.Name & "!" & counter & "MBO" If counter = qt Then rng.Formula = "=iferror(" & aggregate & ",""oddly...

Hi all, Sorry I did submit this to a wrong post. Here I come. I have been trying to work out this formula to auto populate per customer's status with a few steps, by implementing multiple excel functions e.g: replace, cell, aggregate, index: B1 Formula =...

Hello everyone, What is working: 25th Percentile for 1 criteria -AGGREGATE(18,6,$C$1:$C$10/($B$1:$B$10="Green"),0.25) 25th Percentile for 2 criteria - AGGREGATE(18,6,$C$1:$C$10/(($B$1:$B$10="Green")*($A$1:$A$10="January")),0.25) What I am trying to do: Select January or March for the month...

Please, I made a simple template to take grades of my pupils. In the templates, some subjects on a continuum are compulsory (H - K) while the remaining (L- P) are optional, but 2 of them (best 2 with good grades ) to be added to H-K to give the aggregate in Q as indicated in the table below...

Hi All, I recently discovered a way to use the aggregate function in conjunction with index / match to identify min / max values for like records in a table (i.e. if I have a table of animals and their weights, I could use this function to identify the smallest dog, or the largest cat, etc.)...

Hi, I'm trying to make this formula compatible with Excel 2007, I think I just need to replace AGGREGATE with SMALL but I'm getting errors. The INDIRECTS are referring to Data Validation cells where I have user-selectable filter criteria. Here is the original formula that works in modern...

Hello, If anyone is up to the challenge.. I have this formula below that I need to modify but don't know how... And I really need the boards help.. What I need is instead of the formula returning: "T = final temperature of concrete mixture (deg F)" I need it to return: "Wi, Weight of the Ice...

Hello! I have monthly financial data with the months across the row and the financial metrics down the column. I need to aggregate these months into quarterly, annual, or quarterly/annual displays for the user. I wrote formulas to generate the correct headings based on the user selection...

I added the Aggregate Sum to my crosstab query and the user has asked me to sort the columns by this Sum, but I can't see any way to do this. Any help is appreciated!