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

    Plot upper 5 rows when using filter

    you can download an example here: https://docs.google.com/leaf?id=0B5piylDHt3ybOGNlOGUzMDMtNDEyZS00NWJiLThjNzAtNGZkZTIwZTIyYWMw&hl=en_US&authkey=CNGl-v0D
  2. Nunes

    Plot upper 5 rows when using filter

    Ok I'll write it now: In Sheet1 you have your database of filtered data, of which you only want to print the top 5 rows. Let's assume your database uses only 3 columns, A B and C. In column D you will put the value 1 in every cell. In column E you put the subtotal sum of each cell on it's...
  3. Nunes

    Plot upper 5 rows when using filter

    You can export that data into a second sheet, like a "Reporting sheet". Using subtotal formula and a couple of helping columns, you can know what cells are visible and link only the top 5 rows to this "Reporting Sheet", that you print using a A3:A8 type print range. I did this and I can...
  4. Nunes

    Excel.RWA files

    googling it: http://www.econsultant.com/file-extensions-r/rwa-file-extension-reliasoft-weibull-6.html
  5. Nunes

    Round a decimal to the nearest of 0.25, 0.50, 0.75, the whole number

    what about =ROUND( A1/0.25 , 0) * 0.25
Back
Top