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

    Index Match and Summing Query

    hello, Can you please refer attached spreadsheet and advise what is the rror in my indiex match formula and also suggest a formula for the particular summing in columns AL and AM Thanks
  2. E

    Replacement for SUMIF

    HI All, I am currently using a sumproduct formula SUMPRODUCT(($B5=Category)*($A$11=GL_Account)*(AC$2=Date)*(Amount)) When used in a file having massive data, the calculation is slowing down. Is there any way i can replace this with , say for example, INDEX MATCH formula which can speed up...
  3. E

    Index Match not working

    Thanks again Khalid. Worked well
  4. E

    Index Match not working

    Hi, Could you please refer attached worksheet and help where i went wrong with the index match formula ? Thanks
  5. E

    IF with three conditions

    Thank you very much Khalid. It worked. Hi David, thank you very much for the file. I'll go through it soon to see how I can use it to solve my tiered cases
  6. E

    IF with three conditions

    HI , I need help in building a formula to calculate Electrcity charges Example- Electrcity usage is 31,180 kilo watts Pricing would be- 1,1kilowatt to 2500 kilo watts would be charge $0.23 per kilo watt 2,Remaining kilo watts would be charges $0.32 per kilo watt 3, If no usage, price is 0...
  7. E

    Complicated lookup from a table with scales

    In addition to the above requests, i noticed that The formula suggested worked with my previous example. But when i reduced the usage amount, the final result is not what i want. The purpose of this excercise is to ascertain gas cost based on usage shown in column C of the attached...
  8. E

    Complicated lookup from a table with scales

    Thank you David. Please see attached file. Managed to apply formula in the shaded column but this is not complete. Two issues Can you suggest a formula for column AC- which is Step 6 price. this means if the usage in column C goes over and above (10,964*30), it will be charged at 1.756...
  9. E

    Complicated lookup from a table with scales

    thank you very much narayan
  10. E

    Complicated lookup from a table with scales

    Hi Nebu, i think i am not expalaining things clearly here.When you get time, Could you please see attached file where i have put in my comments Thanks
  11. E

    Complicated lookup from a table with scales

    Thnks Nebu. I checked and there is no change in step calculation as shown in the table. Step 6 rate is meant for any consumption over the addition of Steps 1-5 Also when i changed the Total number of 630,346.02, to see what changes are happening, so for example-120,000. It is giving me a...
  12. E

    Drop Down list and supporting functionality

    Thanks heaps Nebu.Exactly what i wanted
  13. E

    Complicated lookup from a table with scales

    Hi Friends, If you could please attached spreadsheet and help advise a Vlookup formula. This involves breaking a cell value and apply different scales based on the table given. Any help would be appreciated
  14. E

    Drop Down list and supporting functionality

    Hi Nebu. I figured solutions for all my questions above. I think I have got confused myself going in to complicated areas. Hence I have simplified my combo box list, however i need to update my CHOOSE function and other related functions as mentioned in the attached spreadsheet. When you get...
  15. E

    Drop Down list and supporting functionality

    HI Nebu, in addition to my above request, could you kindly tell me how have you linked choose function to the combo box. I am trying to apply your workings to my larger file thanks
  16. E

    Drop Down list and supporting functionality

    HI Nebu, HOw do make the date in the combo drop box appear in the same format as mmm-yy. I tried doing this on my own as the drop down list is showing me dates in their "4353" format
  17. E

    Drop Down list and supporting functionality

    Sorry Nebu. Didnt mean to push you. I am going through the file now. This is exactly what i wanted. Thanks a lot. I am going through the file to understand how you did it. I am in Australia too. G'day
  18. E

    Drop Down list and supporting functionality

    Any help please
  19. E

    Drop Down list and supporting functionality

    Any help please
  20. E

    Drop Down list and supporting functionality

    Also I will need to keep the formula as it is in Column "O", as I will add the same formula you had placed in column AB on to column O, when i add old years data-2011, 2012 etc
  21. E

    Drop Down list and supporting functionality

    Thank you very much Nebu for the time you had put in. I was going through your working. I would prefer the two drop down list to function together. Example- When you select "FY Actual" and when you select "Feb-15"- it should give me the values from Jul 14 till Feb 15, and when I select...
  22. E

    Drop Down list and supporting functionality

    Or please try this link http://s000.tinyupload.com/?file_id=26208801267199384356
  23. E

    Drop Down list and supporting functionality

    Hi Nebu, SInce the file is just over 2 mb, cannot upload here, so could you please try this link http://www.filedropper.com/utilitiespl-demo
  24. E

    Drop Down list and supporting functionality

    HI Dear Friends, I stumbled upon a file I was working on when I had to create a Drop Down list with additional set of functionalities. I have attached my sample work with what I need, any help would be greatly appreciated I tried to strip down as much information as possible to upload on the...
  25. E

    Formula to convert date to Quarter

    Thanks Khalid, it worked
Back
Top