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

Recent content by Afarag

  1. A

    evenly distribute numbers across a range

    thanks a lot, it works like a charm
  2. A

    evenly distribute numbers across a range

    Hi vletm, I need to sum Transaction_count till getting 46499 in each day like the first example that sum the values till getting 350 for each column, so the expected result will be like below
  3. A

    evenly distribute numbers across a range

    could you please help me with this formula Peter
  4. A

    evenly distribute numbers across a range

    I need help in building an evenly distribution model, as shown below I want to distribute the summation Total over the Days but keep giving every day only 300 and if the total cell is greater than 300 will fill only 300 then move the rest to the next day and vs if the cell is less than 300 will...
  5. A

    calculate values based on 2 craiteria

    Hello Ashish, I ask to compute attrition rate from two different data sources. I have 2 different sources: 1st: employee headcount (one row per employee) which has all employee details such as Name, ID, Date of Joining, Supervisor name, Department etc. 2nd: showing data for employees who...
  6. A

    export data to sql server

    Hello, please, developers, I ask for help, I have a sheet called "CMS" contains columns from ("A1:BC"). I need to export these data into my SQL server from A2 till last indexed row. I want to use this sheet to stock data into SQL DB as when I update the data then migrate it I need to be...
  7. A

    get result through VBA instead of function

    The problem centered in applying the formula for that huge range, I use that sheet as a template, I use it daily, each day I remove the old data then add the new day and surprisingly 700k row is for one day, so I need to keep the range with active formula as I can't Copy / PasteSpecial, when add...
  8. A

    get result through VBA instead of function

    Hi Marc, I Know that VBA could replace the formulas function without high loading if the range is huge. I need to get the result indexed in columns [N] till [AA] via code instead of formulas. for Access, is there is availability to create formulas like Excel thannks
  9. A

    get result through VBA instead of function

    Hello there, Please, I need help, as I have a worksheet with a huge range of data reach up to 700k rows and more and some columns which have a function. due to the long range, I can't apply the function, as the worksheet take a long time to load, or it crashes. So I search for an effective way...
  10. A

    Insert Comment through pop up form

    hello, please, I ask for help in how can I an empty cell which I will fill it with date value and have a table from two columns [Date] & [Comment]. I need to create two buttons: 1st: Insert comment >> I will fill the empty cell with date value >> click the button >> a text field form will...
  11. A

    Optmize chart bars

    Hello there. Please i ask for an option for how can i control the chart bar manually to optmize the data source. i need to drag the bars up or down to control its data source easely. is that option is available in Excel?. if not? is there any other software provide that option. Thanks alot...
  12. A

    Using Scroll bar to alternate months

    sorry, I got the issue of date picker option going away root cause, then got the way to alternate months via scrollbar
  13. A

    Using Scroll bar to alternate months

    Hello, please, I need your support, I have a horizontal list of 2017 months, and I need to insert a scroll bar to alternate months and year. the workbook contains a date-picker popped up with a double click anywhere, and as soon as I create the scroll bar I found, the date picker option goes...
  14. A

    Get best weighted customer satisfaction grade

    Hello Chihiro, I totally agree with you. but the survey wasn't based on ASA only, the ASA was just a question, and there were questions related to the product/service and other quantifications, but my team works on ASA plan, and how to optimise the service level and control the call center...
  15. A

    Get best weighted customer satisfaction grade

    Hello, please I need help as I have a data for a call center answering call survey, that survey set by a customer to get us his satisfaction grade about his waiting on Queue till call center agent answer his call, I have 4 Inputs: Group of Customer Average waiting time for customers on the...
Back
Top