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

    Max Date from Column Based on Embedded Text in Array

    =MAX(IF(A2:A9<=TODAY(),IF(B2:B9="meeting",IF(ISNUMBER(SEARCH("Bob",C2:C9)),A2:A9)))) Followed by Control/Shift/Enter
  2. P

    Max Date from Column Based on Embedded Text in Array

    I am trying to pull the most recent "date" (column A) in the past if the "activity type" was meeting(column B) and the "participants" included *bob (column C), but bob is in a string of text, not always at the beginning, middle or included at all. I put them in descending order by date for ease...
  3. P

    Rounding Function: Decimal place disappears if zero

    So we are having an issue with the excel 2010 rounding function. If I want to round a number to 2 decimal places, it works until the number is rounded up and the hundreth place contains a zero. In that situation the round function only displays one decimal place. For example: =Round(6.895,2)...
  4. P

    Print Set-Up

    We are trying to do custom reports that are 2 pages: the front is custom per client (each on sheet 1-9) and the back is the same for each client (sheet 10). I want to print Sheet 1 as the front, Sheet 10 as the back for client A; Sheet 2 as the front, Sheet 10 as the back for client B; Sheet 3...
Back
Top