aggregate

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

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

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

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

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

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

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

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