aggregation

Hi all, This forum has already helped me so much in the past months but now I have the first question I couldn't find an answer to anywhere else, really hope someone can point me into the right direction. I have an Excel model where I use a data model and power pivot. Basically user enter the...

Hi all, thanks for your help in advance Essentially i have a spreadsheet I would like to minimise rows imported from the server, using group by. Group by date could compress data down to 5%. However I have around 30 columns and in one file more than 60. It is a bit tedious and error prone if...

Hello Community! I'd like to get your thoughts on how I should approach a new project. We get a daily report from one of our partners with subscriber usage stats. It comes in the form of a CSV and is only 1 day's worth of data. Our goal is to aggregate the data in order to do calculations on...

<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'American Typewriter'}p.p2 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'American Typewriter'; min-height: 14.0px}span.s1 {text-decoration: underline}span.Apple-tab-span {white-space:pre}</style>My original relational...

Hi, I could probably solve this in VBA, but there's got to be a better way to do this in Excel. I'd like collect every instance of an entry in list A, that appears in list B (with its search criteria), and put it in a results table, as shown below. For example:

Hi I am currently building an Excel VBA reporting project . One requirement is for there to be a Pivot Table, which can be built dynamically/change it's fields depending on the source data. It's all going well so far, but I have a problem as follows: My Pivot table variables are as follows...

I am looking for a single formula that will aggregate data for a parent group with a one to many relationship. Imagine I have sales by employee and I have an employee to group mapping table. My goal is to create a table with sales by group without mapping the group to the sales by employee...

Hello all! I hope this isn't one of those forever re-posted questions, but I have spent a couple of days looking over the archives on this site, as well as experimenting with Excel 2007, and am coming up a bit short. Simply put, I would like to take a column of date/time strings, for example...

I'm trying to plot a dataset of frequency of events (=frequency(values,bins)) with timestamps in a chart, and getting some odd behavior. Firstly, my dates are in the format (yyyy.mm.dd hh:mm:ss.000) and are recognized as dates in the worksheet. But, as these dates contain both date and time...