aggregate

  1. J

    Day 1 + Day 2 + Day 3

    Good Morning all, I am very stuck on a problem and hope to get some help. I want to create a DAX measure that aggregates each total by day. Example <tbody> 1/1 8000...
  2. S

    aggregating multiple spreadsheets help needed

    Hi everyone, Here is my problem: Lets say I have 600+ separate excel files containing 3 tabs. The primary sheet is formatted as a form that has 100 questions on it. All the sheets follow identical formatting. The idea is to have some kind of tool/function/query/macro that allows me to answer...
  3. E

    =Aggregate( nightmare!

    Really hope you can help me on this.</SPAN> </SPAN> I`m using Excel 2013, I need to plug into another formula an array that differentiates hidden and visible rows (filtered and not filtered rows) </SPAN></SPAN> The way I was approaching this was creating a dummy column with the aggregate...
  4. C

    Excel MVP needed! Please help with an (Aggregate) RANK

    I have a sample workbook (attached by link) that has 5 worksheets of raw data. Column A contains dates (9/3/2013 - 10/24/2013). column headers are categories/variables (ie: sales, units, etc...) I need a formula that will will give the me the rank for a date (10/24/2013) of of all the...
  5. C

    Rank across worksheet columns

    Hello, Does anyone know of a way to get the rank of an aggregate of multiple columns across sheets in a workbook please? I found a non-workable but good formula: =SUMPRODUCT(--(A$2:A$10+B$2:B$10>A2+B2))+1 BUT! it doesn't allow for a lookup/search variable - the columns are "locked" it does...
  6. J

    Confused on Pivots - how to only include original data >= x

    I have never before had to perform this simple objective with PT. How can I make a rule that determines which values from the original data are used in the aggregate? For example if MyCol is the aggregate, how can I only include values from MyCol that are >10? Note that MyCol is used as the...
  7. C

    Pivot Table aggregate sum is wrong, how to sum without aggregate?

    Hey guys, I need to get rid of the aggregate sum and modify it to show just the sum of one column on a pivot table: Sum of INV $ is a formula, which multiplies sum of AVG * cost (which is not shown). The sum of INV numbers are correct, however if I collapse the category (blank), I get an...
  8. M

    Gantt chart with conditional formatting, multiple cirteria and duplicate data. :) array, index, aggregate

    Hello, I have come close to what I need but need help on the last bit. I hope someone can please help me solve this. I need to produce a gantt chart for batch jobs that run multiple times a day and show that out for a week. So job1 will have multiple rows for each start and end time for each...
  9. N

    Aggregate - Compilation of results from multiple sheets

    Hello, and thanks for providing this forum. I use Excel 2010. I do not understand VBA. I am looking at the Excel Aggregate command video on You Tube at Excel 2010 Magic Trick 797: Check Items In List And Have Them Appear On New Sheet - AGGREGATE - YouTube (Excel Trick 797). I want to gather...
  10. A

    Extract Multiple Records with 3 Criteria

    Hi, I'd like to create a report that displays the values according to 3 criteria. I have 3 drop down boxes that one can select a customer's name, brand, and date (format of Jan 2013 Week Ending 1/26/2013). My drop downs are in a separate sheet under a5, b5, and c5 respectively. I will then need...
  11. S

    Get Name From Array Using Sumif Formula

    Hi, I have done a bunch of searching but just can't really figure out how to phrase what I am looking for, so hopefully someone here can help me out. I have an array that has a bunch of names with dollar values of an account of theirs next to them. People have multiple accounts and come up on...
  12. C

    Collapse rows and aggregate by picking the first non-blank value

    I want to collapse/de-dup rows based on column A, but retain the first non blank value in column B. What I have looks like this: <TABLE style="WIDTH: 202pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=268><COLGROUP><COL style="WIDTH: 101pt; mso-width-source: userset...
  13. A

    Crazy Data Aggregation Question

    Hi All, You have helped me out tons in the past with some of my Excel mindbenders and here is another one if anyone can help! I have 100+ worksheets spread across about nine workbooks with data that needs aggregated together. Each workbook has identical fields between its own worksheets, but...
  14. L

    Is there an aggregate function like SUM which SUBTRACTS?

    Hello, We have a spreadsheet where, instead of adding (SUM) or multiplying (SUMPRODUCT) we want to subtract each item. Preferably we'd like to do this in a pivot table. i.e. Data is: Item Value X -10 X -30 X -20 So, we'd want the value to be -10 - (-30) - (-20) =...
  15. N

    Excel for data aggegation and then disaggregation using co-efficient

    I have a problem in Excel for Supply Chain. I want to aggregate a set of data, change the aggregated data and then disaggregate back to constituents using the same proportion in which they were aggregated . I can do aggregation using pivot tables but then I cannot change and do the...
  16. D

    Aggregate Help

    I'm trying to do a simple example of an aggregate function before I get too far into my project and find out things won't work out. So the example I made was to count numbers which are bigger than 200 in a array, and my formula came out to be: =AGGREGATE(2,6,('array1'/('array1'>200)))I've...
  17. L

    MDX Named Set Help

    Hello, I'm using Excel 2010 with an OLAP cube and I need some help with named sets via MDX. Is it possible to create a named set which basically groups and subtotals data? So if I have 10 employees and they are equally divided in 2 states is it possible to create a named set which is like...
  18. N

    Trying to sum 10 min interval data to 1 hour

    Hello, Help! I am trying to sum up 10 minute interval data into 1 hour. I need to do this for the whole month of October and I have no idea how to do this or if this is even possible in Excel. Any advice is much appreciated! 14:00-14:50 would be the full hour. <TABLE style="WIDTH: 144pt...
  19. J

    aggregating multiple lookup results

    Hi All, I'm looking to create a list (text in a single cell) comprised of values in cells adjacent to the cells in an array which contain a particular value Let's say I have 3 tables thus: <TABLE style="WIDTH: 623pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=830 border=0...

Some videos you may like

This Week's Hot Topics

Top