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

  1. G

    multiple if and condition

    Dear Friends, I am trying to use three AND condition to get the desired result IF($F$8="R")+IF(AND($B$26>729,$B$26<=1825)),(E17/730)*(B26/3) Condition 1 = IF($F$8="R") Condition 2 = IF($B$26>729) Condition 2 = IF($B$26<=1825) Desired result =(E17/730)*(B26/3) But the outcome is throwing...
  2. G

    lookup date for corresponding value

    Thank you friends
  3. G

    lookup date for corresponding value

    Hi... I am try to use hlookup for getting the corresponding date for the values mentioned. But Getting #NA sign. Kindly let me know what is the right formula to be used to solve this. Regards,
  4. G

    translate english text to arabic

    hi friends, Is it possible to translate english name to arabic ? Is there any code which can help me out. Regards, ganeshm
  5. G

    excel vba code for lookup

    thank you so much... i am just learning step by step. I will soon give my best
  6. G

    excel vba code for lookup

    thanks for the file. But i want to update interview status, which is enclosed in the 1st upload. 2nd attachment is only reference for you, it gives you vba code to understand how to work out. I tried but somewhere the formula goes wrong. Just wanted to understand where am i going wrong.
  7. G

    excel vba code for lookup

    yes... i am actually looking for a file like 2nd case. I type all data in master sheet, it collects the data and saves in next sheet. When required i type the name (or number), then i am able to view the complete data with edit option. Therefore, i would be glad to know the way i can sort out...
  8. G

    excel vba code for lookup

    hi vletm, The reason for vba is to edit the record in master sheet and retrieve when required. Posting a similar sample excel workbook for your reference. In this sheet, u can edit, retrieve and view... looking for a similar exercise in the previous enclosed excel workbook. Please refer and...
  9. G

    excel vba code for lookup

    Dear all, Need your assistance to solve the excel vba code in the enclosed excel file. i am trying to lookin values from the next sheet. By reading candidate name, the file needs to fill in the required boxes in the master sheet. kindly advise, Regards, ganeshm
  10. G

    vba code for vlookup

    Hi friends, Just a quick question, is it really not possible to apply bold to a specific text in a cell i.e. say B2 for example, holding vlookup formula ??
  11. G

    vba code for vlookup

    but i have a problem, the cell having vlookup is a variable. It keep changing as and when any new employee joins. Therefore, I don't want to keep it as constant. In such a case, is there any other option so that it reads vlookup.
  12. G

    vba code for vlookup

    So please guide me, how am i suppose to change that
See more
Back
Top