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

    Plot upper 5 rows when using filter

    Now it works, and it works perfect! Thank you so much!
  2. R

    Plot upper 5 rows when using filter

    I found this solution, which works (but not satisfactory): =SUMPRODUCT(SUBTOTAL(9;OFFSET(M5;ROW($M$5:M5)-ROW(M5);0));--($M$5:M5=1)) then just copy for all rows. Buuuut, now I got a new problem. The spreadsheet currently includes 10,000+ rows, and when I started to use this solution the...
  3. R

    Plot upper 5 rows when using filter

    I've checked it out. It works perfectly except one small thing. When I'm starting to sort after certain criterias it get's a reference problem since in the "AUX 3" column it's always fetching the value in the cell above. When the above cell then becomes text, it does not work anymore. I tried...
  4. R

    Plot upper 5 rows when using filter

    Wow, that was an incredible fast answer. Thanks a lot! I will take a look and see if it works :)
  5. R

    Plot upper 5 rows when using filter

    I have a spreadsheet including customer, commodities and volumes. For this I am using data filters to chose which commodity to display. So far nothing strange. I am then plotting what is filtered in a chart. It is actually looking exactly like one of the tutorials on this website...
Back
Top