• 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

    VBA code for Subtracting columns based on index column

    Hi All, I am very new to vba Coding. I am looking for help for writing a vba code which can handle below : India A B C D China E F test G 5 6 7 8 9 10 11 12 13 14 6 7 8 9 10 11 12 13 14 15 7 8 9 10 11 12 13 14 15 16 8 9 10 11 12 13 14 15 16 17 9 10 11 12 13 14 15 16 17 18 10 11 12 13 14...
  2. R

    Formating issue in Pivot table in excel 2003

    Hi Hui, Thanks for this reply. Please ignore my ignorance but I am still not got the desired output. When I fellow the above way, I am getting Repetition of Benchmark field column after each column of Country, where in this case I want single column for all the country column which fall under...
  3. R

    Formating issue in Pivot table in excel 2003

    Hi Hui, Thanks for quick reply. This is really very helpful. But my problem is After doing the above procedure also I am not able to include Benchmark (BTC_1 and BTC_2)in my pivot table in this format. Break Down BTC_1 India japan US UK BTC_2 PK HK NZ OZ oil 100 10 11 12 13 200...
  4. R

    Formating issue in Pivot table in excel 2003

    Hi Guys, I am very new to Excel reporting and need to create a report by use of pivot table. Here is my sample data : Country Sector Benchmark BenchMark_weight Account order country_weight India oil BTC_1 100 1 10 japan oil BTC_1 100...
Back
Top