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

    Multiples formula

    Works perfectly. Thanks a lot
  2. U

    Multiples formula

    I am attaching another excel sheet with more detailed explanation. Thanks a lot
  3. U

    Multiples formula

    Hello excel community, I have struggled to develop 1 conditional formula for multiples as indicated in the attached excel sheet. Kindly please help with that. Thanks in advance for your help
  4. U

    How to generate numbers 0,1,2,3 in adjacent cells

    Thanks Ninja. ROW(A1)-1 works quite well. Your suggestion will help me when I do not need to include the numbers in a formula.
  5. U

    How to generate numbers 0,1,2,3 in adjacent cells

    Thanks a lot. I had just discovered the formula.
  6. U

    How to generate numbers 0,1,2,3 in adjacent cells

    Hi excel gurus. I want a formula to help me have numbers starting with 0 along rows and columns. Please see the attached excel sheet. The ROW(A1) or COLUMN(A1) is ok but I cannot get it to start with 0. I will appreciate your help.
  7. U

    Random formula

    Hello @eibi, can we tweak the formula to do a little bit more please? 1. Distribute adult and young gift receivers among gift providers so that no gift provider will get adults only or under 18 only. 2. When I press F9 the number of gift recipients per providors change. Sometimes some...
  8. U

    Listing loan and repaid amounts in months

    Hello excel gurus, please find the attached excel sheet. I need a formula that will list all loans and repayment in their respective months for each person. The formula should work for many people and many months. Please help. Thanks
  9. U

    Random formula

    Thanks a lot guru. The formula is working perfectly
  10. U

    Random formula

    Thank you so much for this solution. Very helpful. However, there is a minor problem. Sometimes a provider is not assigned a recipient at all, or 1 provider has say 3 recipients while another provider has just 1 recipient. Is there a way we can tweak the formula such that recipients are...
  11. U

    Or function or what else?

    Thank you so much guru. Very informative
  12. U

    Or function or what else?

    Thanks guru. But honestly I do not understand your suggestion. It will take me a while. I am very new to excel. After a while I have come up with this formula...
  13. U

    Or function or what else?

    Thanks for your help. This formula (=IF(VLOOKUP($B3,$O$2:$P$11,2)>VLOOKUP(C$2,$O$2:$P$11,2),$B3&C$2,"")) has almost given me what I want. The only challenge is MXN and ZAR. The problem is that with MXN I only want USDMXN, and with ZAR I only want USDZAR and GBPZAR. I have tried...
  14. U

    Or function or what else?

    Hello, 1. Yes to number 1. Take GBPCAD for example. If I concatenate straight, in range B2:K11 I will have GBPCAD and CADGBP. N1:O10 is used so that the formula returns GBPCAD only, because the number against GBP in N1:O10 is bigger than the number against CAD 2. I need help in table B2:K11 only...
  15. U

    Or function or what else?

    Thanks. Let me clarify. Column H should only have USDMXN as shown in the attached sheet. Column K should only have GBPZAR and USDZAR. I have failed to get one dynamic formula for that. That is why there is no formula in columns H and K. Thanks
  16. U

    Or function or what else?

    Thanks. Manual always works. But with excel you can handle almost all data, whether large or small. That is why I want to learn it more. I know there is a way. I just want someone to help me connect the dot. And I like adventure. Manual is not adventurous
  17. U

    Or function or what else?

    Thanks
  18. U

    Random formula

    Hello, Imagine this. John, Doreen, Brian and Donald are siblings and have their own separate families, with different number of family members (i.e. John has wife and 2 kids, Brian has wife and 4 kids. Donald has wife and 1 kid, Doreen is still single but she is an adult). I want to design a...
  19. U

    Or function or what else?

    Hello excel experts, The problem in the attached sheet seemed simple but it has taken me a while. Please help. Thanks
  20. U

    Random formula

    Hello excel gurus, please see the attached sheet and help. Thanks
  21. U

    Dynamic formula again.

    Hello excel community, please find the attached sheet and help. With thanks
  22. U

    Dynamic addition.

    Working perfectly. Thanks
  23. U

    Dynamic addition.

    Thanks. But it is not working. You might build up on your idea to improve it
  24. U

    Dynamic addition.

    Hello excel gurus, please see the attached sheet and help. Thanks
  25. U

    Gantt chart

    Thanks a lot Ninja.
Back
Top