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

    Problem in macro based file saved in office 2010 and open thenafter in Office 2007

    The file have lost the macro and could not extract the formula from in the excel. We tried to save the file from saving in excel macro enabled version but could not fetch the macro and formula shows #name error.
  2. B

    Repeat All Item Labels in Pivot Table MS Excel 2010

    Do you know in Pivot Table you can have an option of repeating rows by navigating in Design Menu> Report Layout>Repeat All items Labels
  3. B

    Debtors Sales Ratio Using Countback Method

    thanks faseeh for spending your valuable time. The thing is i have calculated this for 1 month. i want to formulae whereby i can stretch this formulae across columns( months). The complicated things is that cumulative value needs to be started counting in descending order from the month...
  4. B

    Debtors Sales Ratio Using Countback Method

    https://docs.google.com/spreadsheet/ccc?key=0Am1DC9Dj3uWedGR4X0txZGF5d3JhZkhTbXdnVVhTQWc dear narayana, the link has been changed to public one and one having the link can change the same.
  5. B

    Debtors Sales Ratio Using Countback Method

    File attached
  6. B

    DSO using Count Back Method

    Is there a method to upload the excel file asking questions. Count back is accounting ratio for Debtors Sales Ratio. General method is Debtors/ Avg Sales, however here he go back in descending order in terms of sales and calculate the days till the value of AR is reached. There are lot of...
  7. B

    DSO using Count Back Method

    I need to calculate the DSO using countback method. it is similar to payback period. the thing is i need one formules. Using Match and Offsett formulae i was able to calculate. but i would like to have the same in a single cell which i can apply across months and states
Back
Top