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

  1. K

    Currency Converter in Sheet

    Check out the following, they have a UDF for exchange rates 'Samir Khan 'http://investexcel.net kanti
  2. K

    how to find the total value

    Hi Sudipto, Look at attached file cheers kanti
  3. K

    How to get last Wednesday of any given month by user

    Hi Ratan, Hope the attached helps. I have used a helper column, but you can build the formula without it kanti
  4. K

    Average of Salary using multiple criteria

    Hi Shahul, see attached
  5. K

    Sumproduct to sum sales between dates

    Check out the attached file
  6. K

    How do I Copy formula from C20:C50000 quickly

    Hi Jack, Did you try Double Clicking on the bottom left corner of the cell you want to copy. If you place you cursor on that corner until it turns into a +, you can then double click the plus and it will copy all the way down.
  7. K

    VBA code to activate unique macros within seperate Excel worsheets

    Hi, Delete the Application.Run from each line and it should work. You can also replace Application.Run with Call kanti
  8. K

    Confused and need help putting salary formula's together

    Hi Robbie, see the attached file, I have tried to make all the parameters dynamic, so you can change the split. The formulas are in the highlighted cells kanti
  9. K

    VBA to break specific link in one worksheet in workbook

    Hi, Try building code with Copy/Paste Special value on the cell where the link is. This will leave on the values in the cell and not the formula.
  10. K

    I need help with formula

    Hi Febausa, Have a look at the cell highlighted in yellow, it gives the formula that should go into L3
  11. K

    formula for getting report

    Hi, See attached pivot file
  12. K

    formula for getting report

    Hi Sambit, I have included a vlookup formula in your file. Please note that the invoice numbers on the sales data tab are formatted as text and not numeric
  13. K

    Stakeholders Analysis Map

    Hi Oren, Not sure if this would help, check out this link: http://www.teylyn.com/articles/excel-articles/xy-scatter-chart-with-quadrants/
  14. K

    Macro - is it possible to reset password using vba

    Hi Kuldeep, Sorry, I do not know how to Encrypt the file at that level. We can programme in VBA password protection once the file is opened. Kanti
Back
Top