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

    HOW TO MAKE DATA SHORT

    All, I have one sales forecast file where I would like to add some information but the data outlook is not visible while I printed on A4. Is there any way to make file visible with all information. file template is uploaded for the reference, please review and update. appreciate for your...
  2. J

    Need excel format for the service sales jobs

    Dear All hope you all doing great, As usual need your expertise, I need one format to track the service jobs to be converted in to sales in a fast track. following are the steps to followup this jobs till it closed and invoiced. please help me how to develop format to track and followup where...
  3. J

    Percentage wise priority in pivot / dash board

    Dear All, Need your expertise, find attached quotation pipeline activity report for three branches from KSA in this file we have 7000 quotations. I would like to develop this file with priorty percentage. required sample format is also attached. please advise either i have to use Pivot /...
  4. J

    vlookup

    Dear all, I have an issue, i need to select two coloumns to apply vlook for comaprision for example, lets i have data in coloumn A and B and i want select this two coulumns and want serach see these data is available in other sheets. Regards Jams
  5. J

    DUPLICATING VALUES TO REPLACED AS ONE VALUE

    Dear All, Hope all r doing great, once again i need your immediate response from you all to the following issue: i have large HVAC parts data consist if 7,646 rows, where as in this data some part numbers and there qty are repating / duplicate and i want this repating part number and their...
  6. J

    MULTIPLE COLUMNS DATA IN ONE ROW WITH DIFFERENT LINES

    Dear All, I need your cool response to my below request. I have an excel file consist if 10,545 coloumns, data transfered from AS400. File is uploaded for your reference. if you see this file coloumn B is one line data but this is splited to many lines and same thing repeating in C and D...
  7. J

    OVERTIME FORMULA [SOLVED]

    Dear All, I have file with the following information please I request some one to advise me how to take total hrs by applying formula in excel Start Time End Time Total Hrs 07:00 PM 06:30 AM 11.5 07:00 AM 06:30 AM 23.5 (One day full) above starting time is in C6 cell...
  8. J

    NEED THIS FILE TO BE DEVELOP IN PIVOT TABLE FORMT / VBA FORMAT THANKS

    Dear All, I would like to share that, I have an AS400 Data converted to excel which consist of 2500 rows and 15 columns. Data in this file is related to HVAC parts here I need your expertise to find out that which part is repeated many times and their quantities with total. Please need your...
  9. J

    PIVOT TABLE FORMAT / VBA FORMAT

    Dear All, I would like to share that, I hanve an AS400 Data converted to excel which consist of 2500 rows and 15 coloumns. Data in this file is related to HVAC parts here i need your expertise to find out that which part is repated many times and their quantaties with total. please need your...
  10. J

    UNHIDE / HIDE TOP ROWS BASED ON DATA VALIDATION FILE

    Dear All, can please help how to find unhide tops rows applied by data validation option. I could not find the rows which was hidden 1:36.
Back
Top