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

    Pivot Charting

    Yes, i had this. But what i wanted is to have the categories shown, even if values were 0. Eitherway, thanks for help.
  2. V

    Pivot Charting

    Thankyou !! it helped a lot.
  3. V

    Pivot Charting

    for sake of better clarity, i have annexed the sample data, charting and expected output. Trust is more clarrified
  4. V

    Pivot Charting

    Dear all I have a data on basis which chart is created using pivot. What I am trying is to maintin the output format irrespective of data Let me clear with a simple example. There are two divisions-EAST & NORTH EAST has placed orders for PC PRINTER and SCANNER NORTH has placed an order for PC...
  5. V

    Spliting Excel File into Many

    thanks kaushik03 for your efforts. the code created 4 files Joseph, Maria, Matt and Lawrence... but with Joseph i wanted region based worksheets. Let me give an example REGION-----------SALESMAN-----XXXX------XXXX---------XXXX NORTH------------JOSEPH--------XXXX------XXXX--------XXXXX...
  6. V

    Spliting Excel File into Many

    I got a datafile which contains REGION and SALESMAN. I want to split these into seperate workbook on the basis of REGION .... AND... within this REGION, the SALESMAN data should be in different worksheet. So suppose for Region A, there are 3 salesman in the data, the code should create a...
  7. V

    on vlookup

    vlookup function returns the first value that is encountered. Is there any option to get the data related to 3rd occurance or so. to clear my query i did like to use the following example. I got this list of bills along with vendor codes 1 VEN1122 MAY PAID-3/7 2 VEN1122 JUN 3 VEN1122...
Back
Top