• 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

    How to create this view

    Hi All, I need your help with below. I have a excel spreadsheet which look like below : Service Id's are repeated across the various company id's. Requirement - To create a view : Total amount need to be splitted equally across the service id's ( for example if total amount is $1000...
  2. A

    Macro to Transpose Data

    Hello All, I have data for around 1000 employees arranged horizontally which needs to be transposed vertically to update the database. There are around 60 columns of data for each employee that need to be transposed. I am attaching a sample excel with this thread. Any help will be highly...
  3. A

    Formula Help

    Hi All, I have an excel file which is set up like below. My requirement is : If we input in cell B9 for example as April then in the summation of parameter A in cell C11 should have summation values of A parameter from Jan , Feb , March & April. Likewise for the other parameters C & FC. I...
  4. A

    Data Representation

    Hi Guys , Need your help!!!! I have a huge spreadsheet(25000+ records ) which is arranged as below: However this data need to be re-arranged in below pattern. The blank cells will have the amount for the respective id & group. Is V lookup using Index/Match is the way out ...
  5. A

    Sumifs on Rows

    Hi, I have a range of data which is in below format : Cities February March April May London 4 6 0 9 Paris 3 3 2 4 New York 2 2 4 4 Tokyo 1 2 4 3 London 7 4 5 1 Paris 3 0 2 3 New Delhi 7 4 2 1 Manila 5 6 7 2 Tokyo 3...
Back
Top