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

    to find and replace in a formula

    Hi, Guity, Have you ensured that 1. "Match entire cell contents" is not checked in the find/replace dialog box? 2. The "Look in" option is enabled with "Formula" and not with "Values" or "Comments"?
  2. M

    Round a decimal to the nearest of 0.25, 0.50, 0.75, the whole number

    Hui, that's really elegant. I wonder how you could have thought that.
  3. M

    Setting Up Due Dates using Work Days only

    I toyed with the idea for some more time and came up with this formula. it works just fine. Requirements first: 1. I need to calculate the sixth working day from the date of receipt of a project. The sixth working day will be the due date. 2.Saturday are working days for most Indian...
  4. M

    Will you teach an online VBA course?

    Excel Hero is not only too advanced, the Indian audience will think about the price twice.
  5. M

    Setting Up Due Dates using Work Days only

    Thank you. I myself should have found the use of Networkdays function :(. I just tried the formula by Pearson and found it to be more useful. I've to try the UDF as I'm not very comfortable with VBA - have to go slowly. Thanks a ton. Murugaraj
  6. M

    Setting Up Due Dates using Work Days only

    Hi, Is there any way we include saturdays but not sundays and omit any date from a given list (say, list of national holidays)? Thanks in advance.
  7. M

    Finding the frequency of a day between two dates

    Hi, I would like to find the number of Sundays in between two dates. Is there a way? Thanks in advance for your help. Murugaraj
  8. M

    10% Discount on Excel School for Forum Members

    Does it apply for Indian students too?
  9. M

    Using sheet names as variables

    Hui, I can't resist but wonder how smart your formula is. thanks a ton. @cyrilz: your trick is good, too; but it is a little roundabout. Thanks for sharing. Murugaraj
  10. M

    Using sheet names as variables

    Oh, but I'm yet to learn macros. My present knowledge of macros is recording and editing them to a certain level. I think it's time I try that too. Thanks, Hui.
  11. M

    Using sheet names as variables

    We can use CELL function to retrieve various data about a cell and use them in formulas too. Is there a similar way to use sheet names? I have a workbook with productivity of each employee in a single table (a table with 20 employee names with their daily productivity). There is another...
  12. M

    Countifs criteria with dates and time

    Thanks Hui, I got the logic. I made a small change and used: =SUMPRODUCT(A2:A10,((INT(B2:B10)=DATEVALUE("6/23/2010"))*(C4:C10=""))). And it worked just fine. Thanks again. Murugaraj
  13. M

    Countifs criteria with dates and time

    Dear Chandoo and Hui, Thanks for your help. My dates have times, so I can use Chandoo's suggestion. However, when I tried, I got the sum wrong (it was 0 always!). I tried to find where I'm going wrong. I get a bizarre result at the following step:INT(C4:C10)="6/23/2010" is always FALSE--even...
  14. M

    Countifs criteria with dates and time

    The first column of my excel sheet contains the number of units (integers); the second column has the despatch date; and the third column contains the due date with time (e.g. 6/29/10 10:38). I'm interested in counting the number of units not yet despatched. That is: count "the number of units"...
Back
Top