• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. W

    Different aggregations in same pivot table

    Hello, Does anyone know if it is possible to use different aggregation methods in the same pivot table? I have a datafile with results for different indicators. They need different types of aggregation: SUM, MAX or AVERAGE. In my source data I have made a column that indicates for each record...
  2. W

    data mining - classification tree

    Hello, Is there a way one could build a classification tree in Excel, such as XLMiner could do (but is very costly software). See e.g. this excel file: http://mande.co.uk/blog/wp-content/uploads/2012/04/epm-data-only.xlsx and this type of classification tree...
  3. W

    named ranges for different columns

    Dear Hui, This is really great. Yes, it does the trick I needed. I'm not sure if I'm feint at heart, but I don't get exactly what the formula's do. This looks like what I've seen in your chart 'my excel age' and I remember not fully understanding that one as well. I will be able to use this...
  4. W

    named ranges for different columns

    records are being added over time (e.g. new partner, new indicator) but not so frequent. and over time data for new columns is added (plan 2012, realised 2012 etc).
  5. W

    named ranges for different columns

    another try: https://rapidshare.com/files/461854999/example_wouter.xlsx
  6. W

    named ranges for different columns

    I posted a sample here: http://www.4shared.com/file/_sOQ5kKL/example_wouter.html Hope you can see my idea there
  7. W

    named ranges for different columns

    Thanks Hui, the first example is helpful. However, it always selects a single value. What I would need is sliders or control boxes that form a name, and the name defines a subset of the data: always more than one row, but it depends how many rows. E.g. 3 'output' type of data that I would like...
  8. W

    dynamic filters

    I'm not so good at macro's and try to avoid them. Hoped there would be a work-around in some way... thanks anyway, wouter
  9. W

    named ranges for different columns

    hello, I have worked with named ranges linked to a form control and a graph. To do that, I had to sort the data and applied names to each group or rows in the data table. Using the form control selected to name=range of data to be used. Does anyone know how I could do that if I want to...
  10. W

    dynamic filters

    Does anybody know a method to link a filter to a cell, or to a form control? The filter are too complicated to use for the users I am working for. Wouter
Back
Top