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

    Countifs formaula not working

    Dear All, Please help me out on the following.. Iam trying to use Countifs formula to find out the student numbers count in each Division with in grades 1 to 10 however its not working. Have attached the Excel file and formula cell is :- Summary Sheet -ColumnB Row 16. Thanks in Advacne
  2. A

    How to round to millions

    Hi All, What is the Formula / command to round off million to the number to nearest millions in MS Excel. for example Rs 1,90,87,169 to 19.1 millions Regards Aditya
  3. A

    Getting one excel tip every day through mail

    Dear All, In Chandoo.org is there any option where I will get one excel tip each day directly to my mail ID. Regards Aditya
  4. A

    MAcro for Sending Mails with attchment

    Dear All, Can anyone help me out with MACRO for sending mails every month with specified text. My requirement is every month I have to send a reminder mails and thanking mails to the contributors ( List around 500 to 1000 ) , now I am doing this task manually like typing the Message and sending...
  5. A

    VLOOK UP is not working

    Dear All, Is there any formula alternate to Vlook up where I can serch amounts even though not in right side( vlook up works for figures where finding amount should right side only or else formula will not work) Thanks for your help.
  6. A

    Finding number of days between two dates

    Dear All, Is there any correct formula to find the number of days between two days. I used to have formula like =Days 360( 1-Apr-12,30-Mar-13)+5. Some times its giving wrong. Earlier i used to use (= 1-Apr-12-30-Mar-13), but it proved be a wrong. Any help in this regard would be highly...
  7. A

    Formula for Time difference

    Dear All, What is the formula for Calculating the difference of time as shown below: 1) Down Time is from 9:05 to 9: 15 am date 20-Dec-12 9:25 to 9: 35 am date 20-Dec-12 9:45 to 9: 55 am date 20-Dec-12 Now i want to know the % of down time in day ( 24 hours) and in month i.e 24...
  8. A

    Data Validation

    Dear All, I need to create a sheet with drop-down list of five names where my client would fill out the data with in those five names & send me. How could i create the same. Best Regards
Back
Top