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

    Blank records are not appearing in the pivot

    Bobhc I have edited the HTML tags. It should look better now. Will try to upload the sample file. Meanwhile, please provide a solution on the above post.
  2. A

    Blank records are not appearing in the pivot

    Crossposting done here -> http://www.mrexcel.com/forum/excel-questions/703346-blank-records-not-being-appearing-pivot.html#post3473676
  3. A

    Blank records are not appearing in the pivot

    I have an excel table as below from where I am generating a pivot table: ---------------------------------------------------------------------- Region Project Name Is this a new Project? ---------------------------------------------------------------------- CE AA Yes CE BB No ESE CC...
  4. A

    Sum of top 3 records based on filtered criteria

    5/5 for chandoo.org
  5. A

    Sum of top 3 records based on filtered criteria

    Thank you NARAYANK991. Your solution worked. The solution is: =SUM(LARGE(--(G7:G21="ME")*--(H7:H21="High")*(I7:I21),ROW($1:$3)))
  6. A

    Sum of top 3 records based on filtered criteria

    Sum of ME High should be 41 (10+15+16). These are the top 3 numbers. I am getting 49. This is adding 8 as well which it should not Remember, I said 'Top 3'.
  7. A

    Sum of top 3 records based on filtered criteria

    I have been struggling to get this for many days, but could not find the exact thing I am looking for on any forum. I have an excel table as below. I need to get the sum of top 3 budgets for every region and project ranking. ------------------------------------------------- Region Project...
Back
Top